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.
I’ve long found it tricky to remember and explain the differences between three similar-sounding waits in SQL Server that all have “LATCH” in the name: PAGELATCH, LATCH, and PAGEIOLATCH waits.
Here’s an illustration that explains these waits, along with wait subtypes.
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.
Ever wondered what it’s like to be a VP or Director of Engineering? I chatted with Alex Robson about leadership in technology, what you can get out of coaching or an MBA program (should you be interested), and what makes a high performing team.
Alex’s site and blog: https://robsonconsulting.services
Yesterday, I was writing some Transact SQL to dust off the cobwebs. I got confused when I was playing around with the STRING_SPLIT function, and kept getting the error:
Msg 195, Level 15, State 10, Line 2
'STRING_SPLIT' is not a recognized built-in function name.
I checked my database compatibility level, which must be 130 or higher for the function to be available. My database compatibility level was 160, so that was fine.
SQL Server performance tuning expert Erik Darling joins the podcast today to chat about how good queries can go bad and how bad queries can get better.
He also answers the question on everyone’s mind: if he was a database, what database would he be?
It can be tiring to have the database constantly be the Prime Suspect for performance problems.
I’ve had many variations of this conversation over the years:
“Something happened, and we’re pretty sure it was the database. Again.”
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.