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 introducing 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:
Latest Features in SQL 2022
Disaster Recovery
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 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 make it easier for organisations to use live data in Azure Synapse.
SQL Server Ledger
New Blockchain technology to create an immutable track record of data modifications. This protects data from tampering, which is helpful for specific situations and uses cases.
Built-in Query Intelligence
This feature enables SQL Server to build parameter-sensitive plans that cache multiple programs per stored procedure. Some new features have also been added to Query Store – which is enabled by default in SQL Server 2022 for all new databases.
Conclusion
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 July 27 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 issues upgrading to the later versions of SQL Server, please feel free to get in touch; we will be delighted to assist.
Digital Samurai are a team of data and SQL experts that have experienced every version through the years – yes, back to SQL Server 6.0! We also have a wealth of experience in upgrades and migrations and are always available to help.