You're busy, so I'll keep this short.
Several months from now, you're gonna have a salary review. Your manager is going to ask what you've been up to, and you're not going to have a lot of great answers. Copilot isn't tracking your successes for you.
sp_Blitz is a free health check script that gives you a prioritized list of things to fix on your SQL Server. Here's what the output looks like: Most of the time, you'll want to work through the warnings in the order that they show up in the results, in priority order. How to Skip Checks…
During the quarantines, I'm looking for new ways to help you level up for free.
I decided to start live-streaming whenever I'm working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I'd do it live on camera while you watch, and talk you through my thought process.
Your boss or client came to you and said, "Give me a quick health check on this SQL Server." Step 1: Download & run sp_Blitz. Go to our download page and get our First Responder Kit. There's a bunch of scripts and white papers in there, but the one to start with is sp_Blitz.sql. Open…
sp_Blitz is our open source free SQL Server health check script.
From a really high level, here's what it does:
There have been so many improvements lately to our First Responder Kit scripts that it was time to update our tutorial videos. Each of these is about ten minutes long and shows how to use 'em:
How to Use sp_Blitz for a Health Check
https://youtu.be/5QAL9itupMA
How to Use sp_BlitzCache to Find Slow Queries
https://youtu.be/EkLuXURMwso
How to Use sp_BlitzIndex to Check Your Indexes
https://youtu.be/8Wo5M7kYO20
You have a monitoring tool, but you've set up an email rule to dump all the alerts into a folder.
You're not particularly proud of that, but it is what it is. You're just tired of the spam.
