Contained Availability Groups – Best Practices from Real-World Projects
Proposed session for SQLBits 2026TL; 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.
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
Speakers
Andreas Wolter's other proposed sessions for 2026
De-mystifying SQL Security: Open Discussion and Real-World Insights - 2026
Enhancing Data Security for SQL Server and Azure SQL: A Strategic Approach - 2026
Practical Performance Monitoring & Troubleshooting for SQL Server and AzureSQL - 2026
Quickstart into database Performance Monitoring & Troubleshooting - 2026
SQL Server under attack: SQL Injection - 2026