Microsoft SQL Server 2022 is here!!!

Microsoft announced that SQL Server 2022 at the Ignite conference, bringing several significant new features that will influence many changes.

A few exciting features of SQL Server 2022 are:

• Failover to Azure SQL Managed Instance

• Parameter sensitive plan optimization

• Seamless analytics over on-premise operational data

• Database Ledger with blockchain functionality

• Query store and Peer-to-Peer replica conflict resolution

• Azure Synapse Link integration

• Industry leading performance, availability

The following image shows the SQL Server 2022 Wheels of Power.

SQL Server 2022 Wheels of Power

Currently, SQL Server 2022 is announced as a private preview. However, you can learn more about it using the following resources.

• SQL Server 2022 Private Preview announcement

• Introduction to SQL Server 2022 (Ep.1) | Data Exposed

• SQL Server 2022: The cloud-connected database (Ep.2) | Data Exposed

• Intelligent Query Processing in SQL Server 2022 (Ep.3) | Data Exposed

• Summit Sessions | Bob Ward | Introducing SQL Server 2022