22-25 April 2026

Contained Availability Groups – Best Practices from Real-World Projects

Proposed session for SQLBits 2026

TL; DR

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. We will discuss availability and manageability aspects, impacts on deployment workflows and security for your high availability architecture and learn valuable best practices.

Session Details

Since their introduction in SQL Server 2012, Always On Availability Groups have become the preferred high availability technology for many DBA’s. SQL Server 2022 introduced Contained Availability Groups, to provide even greater flexibility and simplified management, and SQL Server 2025 introduces even further improvements.
Andreas Wolter, a former senior member of 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 potential challenges. We will discuss availability and manageability aspects, impacts on deployment workflows and security for your high availability architecture and learn valuable 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.

3 things you'll get out of this session

Learn how Contained Availability Groups work Learn about the advantages of Contained Availability Groups Learn to avoid pitfalls using Contained Availability Groups