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
There’s no release date yet, but you can apply for the early adoption program now.