SQL Server 2022 is Here!

SQL Server 2022 becoming generally available was announced on Nov 16th 2022. This is the most Azure-enabled release of SQL Server yet, which is pretty exciting.

A major Azure-enabled feature is the ability to leverage Azure SQL Managed Instance for disaster recovery, which also means we can backup and restore from Azure SQL Managed Instance to SQL Server 2022.

While there are LOTS of SQL Server 2022 new features and improvements, the most exciting to me is Contained Availability Groups.

Contained Availability Groups enable companies to create an Always On availability group that can now contain its own users, logins, permissions, and SQL Agent jobs. No longer will DBAs have to stress about keeping logins and SQL Agent jobs synchronized between Availability Groups, simply create your connection to the AG listener when you are creating users, logins, modifying permissions, or creating AG specific jobs, and those users and jobs are created in the AG specific master and msdb database.

Go take a look at the link above for the boog by Rohan for the official announcement and huge list of improvements.