Search Results for &#8220;sp_blitzindex&#8221;

On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:20 YourbiggestFan: Do you have any plans to write an Azure first version of the first responder kit (sp_blitzfirst and sp_bitzcache)which can get the metrics from query store and thus overcome the issue…

SQLDay Poland Workshop: How I Use the First Responder Kit

Last Updated March 18, 2022

Conferences and Classes

Watch and learn I’m presenting remotely at the upcoming SQLDay Poland on 9-11 May! I’m teaching a one-day workshop, How I Use the First Responder Kit. You’ve downloaded sp_Blitz, sp_BlitzIndex, and sp_BlitzCache from the First Responder Kit, and you’ve run them a few times. You know there’s a ton of advice in there, but…it’s kinda…

[Video] Office Hours: Morning in Mexico Edition

Last Updated March 10, 2022

Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but we want war stories. I have heard your 174 indexes story twice now during recorded classes. Got any more? What are…

[Video] Office Hours: Cabo Home Studio Edition

Last Updated February 24, 2022

Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 02:19 Nullpointer: What are your thoughts on temporal tables, I don’t hear you talk much…

[Video] Office Hours: Ask Me Anything About SQL Server in Cabo

Last Updated January 27, 2022

I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Student: Hi Brent! Why is full backup sometimes slow and sometimes fast in similar situations? This problem will be resolved after restarting the server but it comes back again. 02:58…

[Video] Office Hours: Ask Me Anything About SQL Server

Last Updated January 17, 2022

Let’s pick up right where we left off yesterday. I’ve got more time and champagne, so let’s keep going through your top-voted questions from PollGab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Wilma: Poor code & tuning issues. Evidence = Database Performance Analyzer & sp_blitz. App is the customer’s idea. The dev has got golden…

Updated First Responder Kit and Consultant Toolkit for January 2022

Last Updated January 8, 2022

In this release, sp_Blitz shows some information about clusters and AGs, sp_AllNightLog and sp_DatabaseRestore get some love, and more. Wanna watch me use it? Take the class. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. PowerShell users: run Install-DbaFirstResponderKit…

New Year’s Resolution: Lose Weight in Your Database

Last Updated January 5, 2022

Indexing

Made a New Year’s resolution to lose weight this year? Forget taking it off your waistline – take it off your database instead with: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘size’ Or: sp_BlitzIndex @GetAllDatabases = 1, @Mode = 2, @SortOrder = ‘rows’ This produces an inventory of all the indexes sorted by…

[Video] Office Hours: Black Friday Edition, Ask Me Anything About SQL Server

Last Updated November 27, 2021

Yesterday, I finished setting up my new Apple MacBook Pro with the new M1 Max processor and did its first live stream on my Twitch channel to see how the hardware held up. I was tickled pink – worked great! Here’s what we covered: 00:00 Introductions 03:48 TheGreatFode: Hi Brent, have you ever seen cases…

[Video] Office Hours on the Balcony Part 2

Last Updated November 18, 2021

Picking up right where we left off yesterday, we continue down through the not-so-highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:22 Andrew from Canada: To Null or not to Null? That is the question. On tables with 100M to 1B rows and with several columns that contain data 20% of the time, should…

NOLOCK Is Bad And You Probably Shouldn’t Use It.

Last Updated November 18, 2021

Locking, Blocking, and Isolation Levels

I’m waiting for the YOLOck option. When you put NOLOCK in your query, SQL Server will: Read rows twice Skip rows altogether Show you changes that never actually got committed Let your query fail with an error This is not a bug. This is by design. To understand what happens, read these blog posts in order:…

Updated First Responder Kit and Consultant Toolkit for November 2021

Last Updated November 8, 2021

Just like you, the First Responder Kit has been pretty much stable for the last couple of months. There have been a few small changes, but nothing too big. There are a few pending pull requests that folks are working on around an open source setup checklist, better support for Ola Hallengren’s scripts, and a new…

Updated First Responder Kit and Consultant Toolkit for September 2021

Last Updated November 6, 2021

First Responder Kit, First Responder Kit Updates

I’ve slowed the First Responder Kit update frequency down to once every 2 months. I know from firsthand experience working with clients that folks just can’t patch quickly enough, hahaha. Folks who want to be on the bleeding edge updates can always use the dev branch in Github, too, getting every new fix the moment…

Updated First Responder Kit and Consultant Toolkit for July 2021

Last Updated July 25, 2021

I’m slowing the First Responder Kit update frequency down to once every 2 months. I know from firsthand experience working with clients that folks just can’t patch quickly enough, hahaha. Folks who want to be on the bleeding edge updates can always use the dev branch in Github, too, getting every new fix the moment…

Stop Procrastinating: Master Index Tuning in 1 Month for $195.

Last Updated July 10, 2021

Indexing

You’ve conquered my Fundamentals of Index Tuning and Fundamentals of Columnstore classes, and you’re ready to take it to the next level. It’s time for you to join my Mastering Index Tuning class. When I teach it live – the next one is July 19-21 – it’s 3 days of lectures and hands-on labs where you learn: How to…

Updated First Responder Kit and Consultant Toolkit for June 2021

Last Updated June 1, 2021

If you want to quickly understand the top health and performance issues on your SQL Server, there’s no better, easier, free-er way to do it than the open source First Responder Kit. When you find a bug or want something changed, read the contributing.md file. Wanna watch me use it? Take the class. To get…

Updated First Responder Kit and Consultant Toolkit for April 2021

Last Updated April 20, 2021

This month’s release has two gems for SQL Server 2019 users. First, thanks to Greg Dodd, when you’re dealing with parameter sniffing issues, sp_BlitzWho can now show you the cached and live parameters for running queries. This lets you quickly see when the parameters may be wildly different, leading to issues like incorrect memory grants…

Updated First Responder Kit and Consultant Toolkit for March 2021

Last Updated March 22, 2021

Brad McGehee speaking to the Red Gate PASS party, 2011 Ten years ago, I unveiled sp_Blitz at the 2011 PASS Summit, in front of a live audience. Remember the PASS Summit? Remember live audiences? <sigh> Anyway, to celebrate the 20th anniversary of BrentOzar.com, I’ve thinking back about the last couple of decades to reminisce about what I’ve…

Updated First Responder Kit and Consultant Toolkit for February 2021

Last Updated February 22, 2021