Contained Availability Groups – Best practices and real-world challenges

Since their introduction in SQL Server 2012, Always On Availability Groups have become the preferred high availability technology for many DBAs. SQL Server 2022 introduced Contained Availability Groups, offering even greater flexibility and simplified management.

In this demo-driven session, Andreas Wolter, a former Program Manager in the Microsoft SQL team, will provide a comprehensive overview of the benefits and key considerations of Contained Availability Groups.

You’ll gain insights from real-world projects to help you maximize their advantages and tackle potential challenges.

We will cover:
🔹 Availability and manageability aspects
🔹 Impacts on deployment workflows
🔹 Security considerations for high availability architecture
🔹 Best practices

💡 Join this session to learn about the key benefits and considerations of Contained Availability Groups and why they make your life as a DBA or database application vendor easier.

Learning Objectives:
✅ Understand the advantages of Contained Availability Groups
✅ Recognize potential pitfalls when using Contained Availability Groups
✅ Learn best practices for using Contained Availability Groups

Level: Intermediate