Availability: With Contained Availability Groups user can create an Always On availability group that manages its own metadata objects (users, logins, permissions) at the availability group level in ...

Always on availability groups This feature enables database-level protection by replicating each database transaction on another SQL instance, configured in standalone mode or as a failover cluster.

Now generally available, SQL Server 2022's feature set brings it closer to parity with Azure SQL. Here are the biggest additions to Microsoft's RDBMS software you need to know.