Microsoft Purview access policies for SQL Server 2022 

3 min read

Part of the SQL Server 2022 blog series. Overview Microsoft Purview is a family of data governance, risk, and compliance solutions that help organizations: Gain visibility into data assets across your organization. Data assets can be across data centers, multicloud, and software as a service (SaaS) data.Enable secure access to your data.Safeguard and manage sensitive…Read more

Azure Active Directory authentication for SQL Server 2022 

4 min read

Part of the SQL Server 2022 blog series. Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems. Azure AD Authentication methods  The new functionality extends existing authentication modes, such as SQL authentication and Windows authentication, allowing users to connect to SQL Server 2022 using…Read more

Azure Data Studio July Release with VS Code Updates  

3 min read

Hello, community! As you may already know, Azure Data Studio (ADS) is and has always been focused on building out its own ecosystem of extensions and customized tabs for handling databases, using the UI framework of Visual Studio (VS) Code. As a result, all improvements and/or fixes that are performed on the VS Code codebase…Read more

Improve scalability with system page latch concurrency enhancements in SQL Server 2022 

13 min read

Over the past several SQL Server releases, Microsoft has improved the concurrency and performance of the tempdb database. In SQL Server 2022 we are addressing one of the last areas of contention by introducing concurrent global allocation map (GAM) and shared global allocation map (SGAM) updates which will give SQL Server 2022 a big improvement…Read more

SQL Server 2012 reaches end of support and Microsoft is here to help 

3 min read

Today, July 12, 2022, marks the end of support for SQL Server 2012. This version has had an amazing 10-year run and we want to thank our customers for your investment in learning and using Microsoft SQL Server. Looking forward, there are four great options for data estate migration and modernization that will continue to…Read more

Introducing the SQL Server 2022 blog series 

1 min read

Introducing a new blog post series to highlight new features and enhancements available with SQL Server 2022. SQL Server 2022, now in public preview, is our most Azure-enabled release yet, with continued innovation across performance, security, and availability. With connections to Azure Synapse, Microsoft Purview, and Azure SQL Managed Instance, it is a key offering…Read more

What’s new with SQL Tools 

4 min read

Hello community, the June release of Azure Data Studio 1.37 is here! We are also excited to announce the release of SQL Server Management Studio (SSMS) 18.12. In this Azure Data Studio release, backup and restore to URL was introduced for Managed Instance. Updates were also made to support the Table Designer feature in offline…Read more

Recapping recent updates to client tools in SQL Server 

3 min read

Hello from the SQL Experiences team! As a follow-up to Microsoft Build at the end of May, we thought it was a good time to highlight recent updates for client tools, as we’ve had quite a few. SQL Server Management Studio First, in alignment with the announcement of preview for SQL Server 2022, we released…Read more

Announcing SQL Server 2022 public preview: Azure-enabled with continued performance and security innovation 

4 min read

Part of the SQL Server 2022 blog series. Today, we are excited to announce the public preview of SQL Server 2022. Anyone can now download SQL Server 2022 preview to try the new features in this release. SQL Server 2022 is the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and…Read more

Amplify your database development experience with Azure Data Studio 

5 min read

It is that time again! We are excited to bring new and exciting updates to Azure Data Studio. These updates include the general availability of the Azure SQL Migration Extension, the introduction of advanced features to the Table Designer feature that was initially released in February, some updates to notebooks, Query Plan Viewer, SQL Projects,…Read more