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 Syys 20241h 3min
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 Heinä 20241h 4min
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 Heinä 20241h 2min
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 Touko 202441min
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 Huhti 202444min
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 Helmi 202451min
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 Helmi 202455min
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 Tammi 202450min
