Brent Ozar

Brent Ozar specializes in making SQL Server faster and more reliable.   He's a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience.  He coauthored Professional SQL Server 2008 Internals and Troubleshooting, created sp_Blitz® and sp_AskBrent®, and he loves sharing knowledge at

Making your T-SQL fast isn't really all that different from building and driving race cars. Learn lessons from racing icons that you can apply right away in your databases.
Got a slow application or server, and not sure where to start? Brent will explain how to use the two most popular free tools and how to read their results.
These two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.
PANIC IN THE DATACENTER! Your databases are approaching - or surpassed - the Terrible Terabyte mark. You're pouring money into the SAN, but your data isn't pouring back out as fast as you want. You're terrified to DBCCs or index maintenance because everything takes forever, and you don't have big maintenance windows.
You don't buy a lot of servers, but you're about to deploy SQL Server, and you only get one chance to make it right. Brent Ozar will boil down everything you need to know into just a few simple decisions including SQL Edition, sockets, and RAM.
How does SQL Server build results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be SQL Server. This session is for people who are comfortable writing queries, but not with indexes, statistics, and sargability.
Ever wonder how someone else does it? There’s no right way or wrong way, but in this session you can peer over Brent’s shoulder (virtually) while he takes a few Stack Overflow queries and tries various techniques to make them faster.
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
You're hearing a lot about the new features in SQL Server, but you're not hearing a lot about the drawbacks. Ever wonder why? Join Brent Ozar, the guy behind, for a sarcastic, funny look at SQL Server 2014's "features" and bugs.

Blog posts RSS

My How to Think Like the Engine Class is Now Free – and Open Source 26 Oct 2016
You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. You’ve never had a formal database internals class, and you don’t really have the patience to read a ...

Announcing our 2017 SQL Server Training Scholarship Winners 25 Oct 2016
Right now, all over the world, people are using SQL Server to make the world a better place. Sadly, most of these teams are underfunded, understaffed, and undertrained. They’re doing the best they can with the limited resources they have available, just trying to make a difference. No, ...

First Responder Kit Update: sp_BlitzCache Catches Cursors, Scalar Functions, and More 24 Oct 2016
Every time we take on a client for our SQL Critical Care®, the very first thing we do is run the First Responder Kit scripts: sp_Blitz to get a health check, sp_BlitzFirst to check their wait stats, sp_BlitzIndex to look at their indexes, and sp_BlitzCache to see the most resource-intensive ...

[Video] Office Hours 2016/10/19 (With Transcriptions) 23 Oct 2016
This week, Brent (and only Brent) answers your questions about table partitioning, best practices for VMware configuration, rebuilding indexes, transitioning from physical SQL failover cluster to VMware or Hyper-V, database backups, security issues with cross-database chaining, and why you should ...

Thoughts About the #SQLSummit Day 1 Keynote 21 Oct 2016
I’ll be honest, dear reader: I usually hate the holy hell out of the Summit day 1 keynote. As an example, check out the last keynote I liveblogged – go to the bottom and then read up. (Sorry, I won’t do that style again.) It was awful, one of the worst two hours of presentations...