Episode 260: Contained Availability Groups

Episode 260: Contained Availability Groups

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!

Jaksot(287)

Episode 15 Working at a University

Episode 15 Working at a University

Corporate culture is a BIG deal when it comes to job satisfaction, and it is interesting to see how different sectors can be.  Today we talk with Doug Purnell, DBA at Elon College in North Carolina an...

28 Loka 201525min

Episode 14: SQL Server Clustering

Episode 14: SQL Server Clustering

Clustering is a now tried and true technology to help increase the availability of your SQL Server environment.  I talk with Paul Popovich about his experiences with clustering and how his approach ha...

21 Loka 201523min

Episode 13 Apply Yourself

Episode 13 Apply Yourself

I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny. While not close friends, I have know Kevin for a while and knew he had good stuff. He there sha...

14 Loka 201530min

Episode 12: Database Corruption

Episode 12: Database Corruption

Database corruption is something that will eventually come to all data professionals.  While I have been fortunate to only come across is a handful of times, I was glad that I was able to get back the...

7 Loka 201531min

Episode 11: SQL Server Statistics

Episode 11: SQL Server Statistics

So it turns out an old dog can learn new tricks--or at least that is what happened to me when I chatted with Grant Fritchey from Red Gate software about SQL Server Statistics.  Always taking an opport...

30 Syys 201534min

Episode 10: Test Anxiety and Test Preparation

Episode 10: Test Anxiety and Test Preparation

We mix things up a bit as I chat with Thomas Frank from collegeinfogeek.com about test anxiety and test preparation.  Taking a test can be a big deal and it is always interesting to get other options ...

23 Syys 201532min

Episode 09: Database Automation

Episode 09: Database Automation

Joey D'Antoni has been doing quite a bit with database automation and I caught with him to discuss his experiences about how database automation has helped him be more efficient and have fewer support...

16 Syys 201529min

Episode 08: Database Design

Episode 08: Database Design

I chat will Louis Davidson about database design and get his thoughts on some strategies about how to go about making your design and what tools are available to help you.  It may surprise you that, a...

9 Syys 201533min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-niinku-asia-on
kesken
rss-duodecim-lehti
adhd-podi
aamukahvilla
aloita-meditaatio
rss-liian-kuuma-peruna
rss-valo-minussa-2
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-elamankoulu
rss-psykalab
rss-narsisti
rahapuhetta
salainen-paivakirja
rss-uskonto-on-tylsaa
rss-vapaudu-voimaasi
rss-hereilla