Skip to content
Home » Projects » Contained Availability Groups in SQL Server 2022

Contained Availability Groups in SQL Server 2022

While being an awesome feature introduced in SQL Server 2012, Availability Groups were always missing the ability to synchronize server-level objects between replicas. This finally changed 10 years later, in SQL Server 2022, with the introduction of “Contained Availability Groups”.

A contained availability group is an Always On availability group that supports:

  • managing metadata objects (users, logins, permissions, SQL Agent jobs etc.) at the availability group level in addition to the instance level.
  • specialized contained system databases within the availability group.

In this session, you will:

  • learn about the similarities, differences, and functionalities of contained availability groups.
  • see a live demo of the creation and usage of a contained availability group.
  • learn how to work with the feature of contained availability groups and its pros and cons.

Download Slides Deck

This session was delivered at the following events:


If you want me to deliver this session at an event that you’re organizing, whether it’s an online or venue event, please fill out the form below. Thanks!

See Also

1 thought on “Contained Availability Groups in SQL Server 2022”

  1. I think page/slide is the most comprehensive and detailed presentation material for Contained Availability group.
    Thank you for sharing your valuable information.

    anyway, i am so excited that i accidentally put comment in the presentation form.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.