A query is slow, and you figure out how to collect the query execution plan. Now what?
In this video, I talk “big picture” about what execution plans are, what “cost” is, why to collect “compiled for” values, and the steps I take to analyze execution plans while performance tuning queries.
As a SQL Server DBA, do you need to be a master of PowerShell scripts?
In this 9 minute episode, I talk about how much you need to know about PowerShell, and examples of ways I personally use (and struggle with) PowerShell.
I’ll be attending and presenting at the SQL PASS Summit in Seattle Washington this year from Oct 31-Nov 3. In this week’s 19 minute episode, I share why I’m excited about going and why I’ve purchased a seat for a pre-conference session. I also give my tips on how to get the most value out of a big conference like the PASS Summit.
Over the years, readers have asked me: “How do you stay motivated?” Sticking with a learning plan, blogging, or becoming a public speaker isn’t easy.
In this 15 minute episode, I share how I think about motivation and what keeps me going.
This week’s question from a reader: “How do I deal with interview questions asking about real-world scenarios when I’ve faked three years of experience on my resume?”
Hear my answer in this 14 minute video.
In this episode of “Dear SQL DBA”, I talk about three articles written by members of the SQL Server community on interviewing that I can’t stop thinking about.
Some of the biggest lessons I’ve learned about interviewing come from an interview experience that meant a ton to me – and all my dreams came crashing down.
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.