SQL Server 2022 Features 

By Ryan Freeman

September 23, 2022

SQL, SQL 2022, sql server

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 about 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: 

  1. Parameter Sensitive Plan Optimisation 
  2. Query Store enhancements 
  3. Link to Azure SQL Managed Instance 
  4. Contained Availability Groups 
  5. Azure Synapse Link for SQL 
  6. Multi-Write Replication 
  7. Azure Active Directory authentication 
  8. Azure Purview integration 
  9. SQL Server Ledger 
  10. AWS S3 storage integration 
  11. SQL Server 2022 on Linux 

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: 

What’s new in SQL Server 2022 

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 of 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 need help 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. 

Ryan Freeman

About the author

You might also like

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}