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.
Our love for SQL Server goes way back and as we are very excited for this next instalment; we have decided to break down all the upcoming features in more detail.
Over the coming weeks we’ll be exploring the following new features:
- Parameter Sensitive Plan Optimisation
- Query Store enhancements
- Link to Azure SQL Managed Instance
- Contained Availability Groups
- Azure Synapse Link for SQL
- Multi-Write Replication
- Azure Active Directory authentication
- Azure Purview integration
- SQL Server Ledger
- AWS S3 storage integration
- SQL Server 2022 on Linux
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:
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 ended 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.