Podcast

Tag: podcast

Power BI Performance Tuning with Eugene Meidinger

Power BI Performance Tuning with Eugene Meidinger

By Kendra Little on January 16, 2024

Category: tech-community

Eugene Meidinger stops by the Dear SQL DBA Podcast to chat about Power BI Performance Tuning.

We talk about the various engines and languages used in Power BI and big-picture strategies for getting performance from the start. Eugene then talks about the community of tools and techniques that can be used to dig in and solve performance problems in Power BI.

Continue reading

Automated Deployments and the Art of the Database with Database Michael J Swart

Automated Deployments and the Art of the Database with Database Michael J Swart

In this episode, Michael J Swart joins the Dear SQL DBA Podcast to talk about databases, automation, and how he’s come to illustrate some of the coolest blog posts ever to be written about data.

Continue reading

Jer and Kendar Explore Optimized Locking

Jer and Kendar Explore Optimized Locking

🔥 UPDATE (November 2025): Microsoft has introduced optimized locking v2 with significant improvements. The new version includes Skip Index Locks (SIL) and Query Plan LAQ Feedback Persistence, which further reduce lock overhead. The improvements are most pronounced for nonclustered indexes. Optimized locking v2 is available in SQL Server 2025 and Azure SQL.

SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking.

Jeremiah Peschka joins Kendra (aka Kendar) to talk through the docs and nerd out on locks, blocks, and how to pronounce the acronym “LAQ”.

Prefer to explore optimized locking with a diagram? I’ve also got a little sketchnote for ya.

Continue reading

Common Antipatterns in Database Development (28 minute video/podcast episode)

Common Antipatterns in Database Development (28 minute video/podcast episode)

Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development– but which are incredibly common.

Continue reading

The Manager Guide to Git Training for DBAs - Video and Podcast

The Manager Guide to Git Training for DBAs - Video and Podcast

Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful.

Continue reading