We're back with another SQL Server 2022 feature—Contained Availability Groups. Have you ever failed over to a secondary node and then found a job or login missing? This new Enterprise-only feature aims to solve this problem by 'containing' all the objects—master, msdb, AND the availability database all in one group so you can manage everything you need when you have to fail over. Brandon Leach returns after more than 200 episodes to give us the lowdown on this new feature and walk us through where you should start planning your upgrade. The show notes and video for today's episode can be found at https://sqldatapartners.com/2023/02/15/episode-260-contained-availability-groups. Have fun on the SQL Trail!

Ask this episode

“What did the council decide on item 42?” — answered with the speaker and the moment.

Transcript

Related