Product has been added to your cart.

Search Results for “first responder kit”

Announcing My 2021/2022 Training Class Schedule

Brent Ozar
Company News
0
If you want to attend my live online classes, it’s really easy: just buy a Live Class Season Pass and you can drop in on any class that works for your schedule. I recommend attending ’em in this order: Fundamentals, required, in this order: Index Tuning, Query Tuning, Parameter Sniffing Fundamentals, optional: Columnstore, TempDB (can be…
Read More
Brent Reading Book

9 Signs Your T-SQL Might Fail a Code Review

Brent Ozar
T-SQL
28 Comments
It’s hard to set absolute rules about, “Feature X should absolutely never be used.” However, there are some features that set off alarm bells when I see them. Usually, when I start asking more questions about when we’re using those particular features, I get answers of, “Oh, I didn’t know that was a problem.” As…
Read More

Announcing Fundamentals Week: May 10-14, $295

Brent Ozar
Company News
0
You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watching recordings or stepping through demos yourself, but…you just can’t block…
Read More

Free TempDB Training Class Next Monday

Brent Ozar
TempDB
1 Comment
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind…
Read More

Azure SQL DB Frequently Asked Questions

Brent Ozar
Azure SQL DB
20 Comments
I’ve seen your search history. Let’s get you some answers. Is Azure SQL DB PaaS, IaaS, or SaaS? Azure SQL DB is platform-as-a-service (PaaS). Microsoft manages most common database tasks for you, and they act as your DBA. This also means that like a DBA, Microsoft will tell you “no” if you try to implement…
Read More

How To Set Up Your SQL Server Training Class Lab VM

Brent Ozar
29 Comments
If you’re taking Fundamentals of Columnstore or any of my Mastering SQL Server classes, you’re going to need your own SQL Server VM to follow along with the labs. The setup is exactly the same for all of those classes, so as long as you’ve set up for any of ’em, you’re good to go.…
Read More

3 Ways to Prove Your SQL Server Storage is Slow

Brent Ozar
I can smell your storage burning from here Thanks for attending my session. Here are the resources: The slides (PDF) Download the free First Responder Kit or get it from Github Then, to prove your SQL Server’s storage is slow: Wait Time with sp_BlitzFirst @SinceStartup = 1 In the Wait Stats section, look for PAGEIOLATCH…
Read More

I’ve Received Your SQL Server’s Data.

Brent Ozar
“Hey, I see the problem already!” I’ve received your SQL Server’s data, and here’s what happens next: At my next break, I’ll review the data. I’ll look to make sure that I’m a good fit. (I’m typically booked weekdays, so I review this data during lunch or after my client workday finishes.) If I’m a…
Read More

0 – Prerequisites Before the Class

Brent Ozar
2 Comments
Hi, Brent here! I’m really excited to welcome you to class. Get your brain ready by taking the classes in order. I recommend that you take the classes in this order: How to Think Like the Engine How I Use the First Responder Kit Fundamentals of Index Tuning Optional: Fundamentals of Columnstore (you can skip…
Read More

What It Takes To Write Two Blog Posts

Brent Ozar
Blogging, Videos
2 Comments
This week, I published two blog posts: How Bad Statistics Cause Bad SQL Server Query Performance How Scalar User-Defined Functions Slow Down Queries Let’s talk about the process of writing ’em. A couple I was putting together this week’s First Responder Kit release, I realized sp_BlitzIndex didn’t have URLs for a couple of common families…
Read More

When You’re Troubleshooting Blocking, Look at Query #2, Too.

Brent Ozar
Locking, Blocking, and Isolation Levels
2 Comments
When I’m troubleshooting a blocking emergency, the culprit is usually the query at the head of a blocking chain. Somebody did something ill-advised like starting a transaction and then locking a whole bunch of tables. But sometimes, the lead blocker isn’t the real problem. It’s query #2. Here’s a sample scenario: A long-running select with…
Read More

How Scalar User-Defined Functions Slow Down Queries

Brent Ozar
T-SQL
10 Comments
When your query has a scalar user-defined function in it, SQL Server may not parallelize it and may hide the work that it’s doing in your execution plan. To show it, I’ll run a simple query against the Users table in the Stack Overflow database. SELECT TOP 100 DisplayName, Location, Reputation, Id FROM dbo.Users ORDER…
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?