Intelligent Query Processing: degree of parallelism feedback 

3 min read

Part of the SQL Server 2022 blog series. DOP inefficiencies are a constant challenge; Current DOP methods are inefficient The degree of parallelism (DOP) with which a query is executed can greatly impact its performance. Any time a query is using parallelism, there is always the question of if it’s using the right amount of parallelism. Read more

Backup and restore to URL for S3-compatible object storage 

2 min read

Part of the SQL Server 2022 blog series. Backup and restore to simple storage service (S3)–compatible object storage is a new feature introduced in SQL Server 2022 that grants the user the capability to back up or restore their databases using S3-compatible object storage, whether that be on-premises, or in the cloud. What is object storage? Read more

Query Store is enabled by default in SQL Server 2022 

6 min read

In SQL Server 2022, Query Store is now enabled by default for all newly created SQL Server databases to help customers better track performance history, troubleshoot query plan–related issues, and enable new query processor capabilities. Read more

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

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