Brent Ozar Unlimited®

In this 76-minute session, I’ll show you how to use the latest features of sp_BlitzIndex to rapidly improve performance on an existing database. I’ll show you how to figure out quickly if you’ve got too many indexes or not enough, and then demonstrate how to get advice from AI on how to consolidate them in seconds.

Can I be honest with you for a second?

It makes my skin crawl when I hear database people smugly answer a question with “It depends!”

Because most of the time, when they do it, they chuckle as if they know something, and as if what they just said illustrates what an awesome expert they are. They elbow their DBA buddies, who also scoff and nod because they’re in ...

If you do a lot of query tuning, you’ve probably come across Richie Rump’s StatisticsParser.com. Now, it’s even easier to use.

Now, it’s even easier to use. Down...

Our cruise ship pulled into port in Victoria, Canada, so before we head out to the Butchart Gardens, let’s go through your top-voted questions from https://pollgab.com/room/brento.

When I first hired Richie over a decade ago, the very first task I assigned him was to build The Consultant Toolkit.

I said, “Whenever I’m working with a client, I have to gather the same data over and over. I run scripts like sp_Blitz, sp_BlitzIndex, sp_BlitzFirst, and so on, copy/pasting that data into a spreadsheet for later review. Then I run sp_BlitzCache a bunch ...