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 231: Mental Health and Wellness in IT

Episode 231: Mental Health and Wellness in IT

Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with ...

11 Elo 202159min

Episode 230: RTO & RPO

Episode 230: RTO & RPO

No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss...

4 Elo 202141min

Episode 229: Data Migration Assistant

Episode 229: Data Migration Assistant

The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the n...

21 Heinä 202143min

Episode 228: Predicting Application Problems with Database Metrics

Episode 228: Predicting Application Problems with Database Metrics

As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consi...

14 Heinä 20211h 7min

Episode 227: SSDT Methodologies for DB DevOps

Episode 227: SSDT Methodologies for DB DevOps

Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in...

23 Kesä 20211h 9min

Episode 226: SQL Server IaaS Agent Extension

Episode 226: SQL Server IaaS Agent Extension

Let's say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don't have to worry about the hardware, managing the software can be problematic. T...

9 Kesä 202158min

Episode 225: Dashboard Design Principles

Episode 225: Dashboard Design Principles

Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the r...

26 Touko 202156min

Episode 224: The Standup Meeting

Episode 224: The Standup Meeting

Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time.  Long form conversation on a single topic is also the place we want to get back to in our podcast.  The show notes a...

28 Huhti 202124min

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