SQL Server 2022 is coming and should be released later in 2022. At the time of writing, you can now download SQL Server 2022 preview to try the new features in the latest release. ‘SQL Server 2022 is the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability.’ – Microsoft.
At Microsoft Ignite (November 21), Microsoft started to introduce the new features of SQL Server 2022. If you want to have a watch (13 minutes), then here is Bob Ward demonstrating some of the new features:
With the latest version you can failover from your on-premises SQL Server 2022 to an Azure SQL DB Managed Instance and back the other way. The Azure SQL Managed Instance can also act as a read-only copy for reporting workloads which is fully synchronised with the SQL Server 2022 on-premises version.
Azure Synapse Integration
The new integration between SQL Server and Azure Synapse will help avoid big ETL jobs and will also mean that it will be easier for organisations to use live data in Azure Synapse.
SQL Server Leger
New Blockchain technology to create an immutable track record of data modifications. This protects data from tampering, which is useful for certain situations and use cases.
Built-in Query Intelligence
This feature enables SQL Server to build parameter-sensitive plans that cache multiple plans per stored procedure. There have also been some new features added to Query Store – which is enabled by default in SQL Server 2022 for all new databases.
Are you excited by the new version of SQL 2022? At Digital Samurai we certainly are! We would love to hear your thoughts on this latest version.
It may also benefit you to know that on the 27th July 2022, extended support will end for SQL Server version 2012. Is this a version you are using, or any prior?
If you have any questions on SQL Server 2022 or upgrading to the later versions of SQL Server then please feel free to get in touch and we will be very happy to assist.
Digital Samurai are a team of data and SQL experts that have that have experienced every version through the years – yes, all the way back to SQL Server 6.0! We also have a wealth of experience in upgrades and migrations and are always on hand to help.