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.
Read the show notes and listen to this podcast episode here:
https://sqldatapartners.com/containedags or /260
Show your love for the SQL Data Partners Podcast with your own t-shirt!
https://sqldatapartners.com/tshirt
Support the podcast: https://streamlabs.com/sqldatapartners
Follow us on social media:
Twitter: @sqldatapartners
LinkedIn: SQL Data Partners, LLC
Facebook: SQL Data Partners
Instagram: sqldatapartners
Subscribe on Twitch:
/ sqldatapartners
#containedavailabilitygroups #sqlserver #sqldatapartners