Product has been added to your cart.

Search Results for “first responder kit”

Our PASS Summit 2012 Schedule

Jes Schultz
#SQLPass, Writing and Presenting
0
Next week, the Brent Ozar Unlimited® crew will be attending PASS Summit in Seattle, WA. It’s a busy week, full of networking, learning, and teaching. Here are a few of our highlights. Want to add our sessions to your schedule, and view more information at your fingertips? PASS Summit has gone mobile with Guidebook! It’s…
Read More
Pocket Square

sp_BlitzIndex®

Brent Ozar Unlimited Team
sp_BlitzIndex® – SQL Server’s Index Sanity Test Your SQL Server indexes may be less sane than you think. Download sp_BlitzIndex® to find out– or scroll on down and watch a video to see how it help you find out: Do you have duplicate indexes wasting your storage and memory? Would you like help to find unused…
Read More
Pocket Square

Home

Brent Ozar
Hi. I’m Brent Ozar. I make Microsoft SQL Server go faster. Since the late 1990s, I’ve progressed from developer, to sysadmin, to DBA. I’ve managed performance and reliability for tough servers: tens of terabytes, thousands of databases, tens of thousands of queries per second. I’ve taught at conferences around the world including the PASS Summit,…
Read More
Pocket Square

SQL Server Training Classes by Brent Ozar

Brent Ozar
One-Day Fundamentals You need to make SQL Server fast and reliable. I do this stuff in real life every week, and I can teach you how to make it happen. Start with the top left box (How I Use the First Responder Kit) and then only take classes that border classes you’ve already taken. For…
Read More

We’re Presenting at the #SQLPASS Summit 2012!

Brent Ozar Unlimited Team
#SQLPass
0
All four of us – Brent, Jeremiah, Jes, and Kendra – got sessions approved for the PASS Summit in November!  Here’s what we’ll be covering: Shazam! We’re speaking at the PASS Summit! A Developer’s Guide to Dangerous Queries – Jeremiah Peschka Jeremiah says: “SQL Server does a good job of working with whatever garbage we…
Read More
Pocket Square

Only One TempDB Data File

Brent Ozar
Blitz Result: Only One tempdb Data File SQL Server uses a shared workspace database called tempdb to handle a lot of system tasks (as well as user-created temp tables.) Query operations like joins and aggregations happen there. Online index rebuilds and INSTEAD OF triggers are also done in tempdb. Table spools and ORDER BY too. (It’s a busy…
Read More
Pocket Square

sp_Blitz® – Free SQL Server Health Check Script

Brent Ozar
You’ve got a Microsoft SQL Server that somebody else built, or that other people have made changes to over the years, and you’re not exactly sure what kind of shape it’s in. Are there dangerous configuration settings that are causing slow performance or unreliability? You want a fast, easy, free health check assessment that flags…
Read More
Pocket Square

Thanks for registering. You’re now in an elite club. Well, a club.

Brent Ozar
Cheers! Alright, you’re in. Here’s a direct zip file link to my SQL Server First Responder Kit (zip). It’s full of stuff to help make your SQL Server faster and more reliable. I’d suggest opening sp_Blitz.sql first in SSMS. Run that, and it creates the sp_Blitz stored proc – you can put it in any database you…
Read More

How to Use sp_WhoIsActive to Find Slow SQL Server Queries

Brent Ozar
SQL Server
SQL Server database administrators need to be able to quickly find out what queries and stored procedures are running slow.  Microsoft includes sp_who and sp_who2 in SQL Server 2005 and 2008, but there’s a much better tool, and it’s completely free. In this five minute tutorial video, I explain how to use sp_WhoIsActive from Adam…
Read More

[Video] Office Hours at Sunrise (No Really)

Brent Ozar
Videos
0
I’ve got a really sensitive lens (Sigma 16mm f/1.4) on my camera, so often when I record these at sunrise, it’s already too bright for you to see the sun. This time, I went down to the beach a little earlier, and through the video, you can see the light really pick up. Here’s what…
Read More

[Video] Watch Brent Write Queries

Brent Ozar
Videos
3 Comments
This morning, I wanted to write a few new “background noise” queries for my Mastering classes. In those classes, the students run live workloads against the Stack Overflow database and troubleshoot performance issues, and the more of a varied workload I’ve got running, the more realistic it feels. For this session, I specifically wanted to…
Read More

[Video] Watch Brent Write T-SQL

Brent Ozar
First Responder Kit, Videos
2 Comments
This morning I worked on a new check for sp_BlitzFirst to find statistics that were updated in the last 15 minutes, possibly causing plan caching issues and parameter sniffing. I streamed it live, and you can watch. In part 1, the first hour, I write the proof-of-concept query: In part 2, the second hour, I…
Read More

[Video] Watch Brent Work on sp_Blitz

Brent Ozar
sp_Blitz, Videos
11 Comments
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…
Read More
Portrait in T-SQL

My 11 Favorite 2019 Blog Posts

Brent Ozar
Company News
4 Comments
Yesterday, I showed the stuff you read the most, but enough data – now, let’s talk about feelings. These were the 11 posts I remember with the most fondness, in date order. I did indeed like some of the ones from yesterday’s list a lot, but I’m going to set those aside. Erik and Tara…
Read More
Brent Ozar

Hi! I’m Brent Ozar.

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.

Want to advertise here and reach my savvy readers?