Posts by Brent Ozar

I’m at sea again, this time cruising aboard the Disney Treasure off of St. Thomas. Let’s go through your top-voted questions from https://pollgab.com/room/brento. Office Hours: Database Q&A Off St. ThomasWatch this video on YouTube 00:00 Start 01:40 DbaMan: You have been reulctant to turn on ADR. It is required for optimized locing in SQL Server…

I’m back in the home office to take another round of the top-voted questions from https://pollgab.com/room/brento. Office Hours: Back in Vegas EditionWatch this video on YouTube Here’s what we covered: 00:00 Start 00:52 chris: After your time at SQLBits you’d posted about the number of SQL Server consultants who were very opposed to AI. What…

In this live stream recording, I’ll show you how to use the latest features of sp_BlitzCache to rapidly improve performance on an existing server. I’ll show you how to find your server’s top bottleneck, find the queries causing that bottleneck, and then demonstrate how to get advice from AI on how to tune them in…

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…

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. Office Hours: In Port in Victoria, CanadaWatch this video on YouTube Here’s what we covered: 00:00 Start 02:17 Janis: Hey Brent, Deleted million of rows from Azure SQL clustered…