What’s New in SQL Server 2022

Today at Microsoft Ignite, Microsoft started dropping new details on the next version of SQL Server, 2022. Here’s a 13-minute video from Bob Ward explaining and demoing some of the new features:

The new features include:

Failover back/forth from SQL Server 2022 and Azure SQL DB Managed Instances, including restoring versionless databases from Azure SQL DB Managed Instances down to on-premises SQL Server 2022 Azure Synapse Link integration to avoid big ETL jobs between SQL Server and Azure Synapse SQL Server Ledger – blockchain immutable histories of tables Parameter-sensitive plan optimization that caches multiple plans per stored procedure