I’m thrilled to have just finished and published a new course on Automatic Tuning in SQL Server. This feature is available in SQL Server 2017+ and Azure SQL Database.
Update: this course is now open and totally free to all.
I’m honored to be heading to the Microsoft MVP Summit. I really enjoy this conference– it’s not my first time going, so I know the ropes. I’m looking forward to seeing a bunch of old friends AND to connect to lots and lots of new people.
But even though I am familiar with the conference, I have a list of things I do to get ready and prepare. That’s because…
This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public.
I attended this session live at the conference, and I remembered that there was one specific part on memory limits in Query Store that I wanted to watch again. I’d jotted down a note about it, but things were flying by and my note was gibberish.
I got a great question about transactions by email recently about transactions.
When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.”
This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes of video with scripts that you can use to reproduce and solve the problem yourself.
I got a question last week from a very smart fellow:
How can I tell when statistics were last updated for a heap?
Before I could email him back, I soon got another email in which he answered his own question.
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.