New Free Webinars! Index Tuning, Free Q&A, and Isolation Levels
I’ve got a whole slew of free webcasts and events coming this spring. I’m excited about each and every one of them!
I’ve got a whole slew of free webcasts and events coming this spring. I’m excited about each and every one of them!
I recently wrote a fairly complicated post, called “Forced Plan Confusion: Is_Forced vs Use Plan = True.”
You do NOT need to go read that post to understand this one. I think I’ve found simpler way to explain the most important part of that post - and why it’s A Very Good Thing.
You may have noticed that there’s something about cartoons combined with SQL Server that makes me happy. Having those images on my desktop inspires me and helps me feel creative. Work should involve fun.
SQL Server Management Studio version 17.5 adds a welcome feature for execution plans: a new visual attribute named EstimateRowsWithoutRowGoal.
I’m at the Microsoft MVP Summit in Redmond, Washington this week. This is a great event for learning from the folks building amazing new technology at Microsoft, giving feedback and representing the community, and meeting and learning from other MVPs from around the world.
Identifying that a query plan has been bossed around in Query Store can be a bit tricky, because it can appear in different ways.
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.
Copyright (c) 2024, 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.