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!

Episoder(287)

Episode 279: SQL Server Migrations Demystified

Episode 279: SQL Server Migrations Demystified

If you use SQL Server, you will eventually have to migrate that instance somewhere – to a new version, a new server, the cloud . . . somewhere. Or perhaps you'll find yourself migrating from another d...

20 Sep 20241h 3min

Episode 278: Running SQL Server on Azure VMs

Episode 278: Running SQL Server on Azure VMs

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right choice? Find out in this insightful episode with Anders Pedersen! With over 10 different SQL Serv...

30 Jul 20241h 4min

Episode 277: PostgreSQL for the SQL Server Crowd

Episode 277: PostgreSQL for the SQL Server Crowd

Is testing out pgAdmin on your to-do list? In this episode of the podcast, we chat with Ryan Booz, a PostgreSQL advocate at Redgate, about how a SQL Server professional might begin a dive into Postgre...

15 Jul 20241h 2min

Episode 276: Dynamic SQL and Testing in Isolation

Episode 276: Dynamic SQL and Testing in Isolation

Listener beware! This episode is full of danger as we tackle an interesting use case for Dynamic SQL. Dynamic SQL generally has a bad reputation in SQL Server circles, and with good reason. Dynamic SQ...

21 Mai 202441min

Episode 275: Machine Learning and Power BI

Episode 275: Machine Learning and Power BI

What kinds of problems are organizations solving with Machine Learning? In this episode, we explore a situation where a public works department was looking for more accurate information to predict fut...

16 Apr 202444min

Episode 274: A CMM Case Study

Episode 274: A CMM Case Study

After discussing the Capabilities Maturity Model in our last episode, it was fate when Andy Levy reached out and suggested a topic which sounds like a case study about his experience with CMM. As the ...

22 Feb 202451min

Episode 273: The Capability Maturity Model for Data Professionals

Episode 273: The Capability Maturity Model for Data Professionals

Have you ever felt stuck in a rut, repeating the same tasks, while knowing there is room for improvement? The Capability Maturity Model may be a way for you to start contributing to those improvements...

2 Feb 202455min

Episode 272: Performance Tuning Scripts

Episode 272: Performance Tuning Scripts

Do you find yourself repeating the same actions when pulling SQL Server performance metrics? Performance tuning a troublesome SQL Server can be a challenge. Luckily the community continues to produce...

10 Jan 202450min

Populært innen Fakta

fastlegen
dine-penger-pengeradet
relasjonspodden-med-dora-thorhallsdottir-kjersti-idem
treningspodden
foreldreradet
dopet
merry-quizmas
jakt-og-fiskepodden
rss-strid-de-norske-borgerkrigene
sinnsyn
sovnlos
podme-bio-3
hverdagspsyken
rss-kull
gravid-uke-for-uke
tomprat-med-gunnar-tjomlid
rss-kunsten-a-leve
fryktlos
level-up-med-anniken-binz
rss-var-forste-kaffe