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 39: Set statistics and StatisticsParser.com

Episode 39: Set statistics and StatisticsParser.com

Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performance, using SET STATISTICS, and the story behind his Sta...

13 Huhti 201630min

Episode 38: SQL Server 2016 Feature Review

Episode 38: SQL Server 2016 Feature Review

Compañeros! You heard rumblings about how awesome SQL Server 2016 is, right?  I talk with Rick Heiges about the wins he's seen for his clients using SQL Server 2016, including how one client's move fr...

6 Huhti 201628min

Episode 37: PowerBI and the DBA

Episode 37: PowerBI and the DBA

In this episode of the SQL Data Partners podcast I sit with Patrick LeBlanc during SQL Saturday RVA. We chat about Microsoft PowerBI. PowerBI is a business intelligence tool that easily connects dispa...

30 Maalis 201627min

Episode 36: SQL Server Virtual Machines in Azure

Episode 36: SQL Server Virtual Machines in Azure

You can host SQL Server on Azure Virtual Machines in a variety of configurations, ranging from a single database server to a multi-machine configuration.  In this episode of the SQL Data Partners Podc...

23 Maalis 201631min

Episode 35: Position Yourself to Better Opportunities

Episode 35: Position Yourself to Better Opportunities

On Episode 35 of The SQL Data Partners Podcast, I talk with Philip Morgan of The Positioning Manual for Technical Firms. Philip’s book has influenced my work at SQL Data Partners, so I wanted to bring...

16 Maalis 201634min

Episode 34: In-Memory Tables

Episode 34: In-Memory Tables

Hello, compañeros! You’ve heard of Hekaton and in-memory tables before, but what does in memory really mean for your database? Perhaps you have questions like I did, like how does in memory OLTP diffe...

9 Maalis 201643min

Episode 33: From Developer To DBA

Episode 33: From Developer To DBA

Many developers will make the transition to the DBA role and in this episode I chat with Amy Herold about making that very move.  Amy started as a C#/.NET developer and moved into the database world a...

2 Maalis 201629min

Episode 32: Up Your Game With PowerShell!

Episode 32: Up Your Game With PowerShell!

PowerShell, isn't that a Windows Administration tool?  This is certainly how it is positioned by Microsoft, but why should the DBA community give it more than a passing glance?  My guest is Mike Fal a...

24 Helmi 201631min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-valo-minussa-2
rss-niinku-asia-on
aamukahvilla
rss-narsisti
adhd-podi
rss-duodecim-lehti
rahapuhetta
aloita-meditaatio
kesken
rss-elamankoulu
koulu-podcast-2
salainen-paivakirja
rss-uskonto-on-tylsaa
rss-liian-kuuma-peruna
rss-luonnollinen-synnytys-podcast
rss-koira-haudattuna
rss-hereilla