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 223: Podcast Update

Episode 223: Podcast Update

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episo...

14 Huhti 20219min

Episode 222: Azure Arc-enabled Data Services

Episode 222: Azure Arc-enabled Data Services

Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from th...

24 Maalis 20211h 4min

Episode 221: SQL Trail March 2021 Retrospective

Episode 221: SQL Trail March 2021 Retrospective

Virtual conferences are just not the same as the conferences we are used to, but we're still determined to provide a good learning and networking environment for our friends. We very much miss having...

22 Maalis 202139min

Episode 220: Microsoft Ignite Recap

Episode 220: Microsoft Ignite Recap

As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss someth...

10 Maalis 202145min

Episode 219: SQL Server Inventory

Episode 219: SQL Server Inventory

How do you document your SQL Server environments? I can remember walking through Brent Ozar's takeover script back in the day and how cumbersome it was to put all that information together. We have a ...

24 Helmi 202147min

Episode 218: File Growths

Episode 218: File Growths

In this episode of the SQL Data Partners Podcast, Eugene and I go back to our DBA beginnings and talk about database file growth, how to manage files and how to tell when a file has grown. The show no...

17 Helmi 202130min

Episode 217: A Little Something About A Few Things

Episode 217: A Little Something About A Few Things

The story begins with a process that has been running forever and suddenly decides to cause grief by filling up tempdb. We talk about patching, and we talk about mental health. We talk a little about ...

10 Helmi 202134min

Episode 216: EDI vs ETL

Episode 216: EDI vs ETL

When working on a customer on an import process, she made the comment—if we were doing true EDI, we'd [Do X]. The comment got me thinking—Aren't we working on an EDI process? As someone who frequentl...

3 Helmi 202132min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-niinku-asia-on
kesken
rss-liian-kuuma-peruna
rss-narsisti
adhd-podi
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-duodecim-lehti
rss-psykalab
aamukahvilla
aloita-meditaatio
psykologia
rahapuhetta
rss-elamankoulu
rss-valo-minussa-2
rss-arkijarki
rss-honest-talk-with-laurrenna
rss-mental-race