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
Brent Ozar has submitted 5 sessions for SQLBits XIV, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

You're using Profiler to trace queries, but you feel like you're still missing something. In just one hour, Brent Ozar will show you how to use much better free, easy tools to catch the killer queries lurking in the shadows.
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 store data in SQL Server, but you don't have enough work to keep a full-time DBA busy. In just one session, you'll learn the basics of performance troubleshooting, backup, index tuning, and security from Brent Ozar, recovering developer.
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.
This is not one of those career sessions that tells you to be friendly and network - forget that. Brent Ozar will explain why shaking hands doesn't work, what web page you should build right now, and how to get started with his 3-year career plan.

Previous Sessions

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.

Blog posts RSS

Announcing sp_BlitzCache™ v2.4 31 Oct 2014
Welcome to sp_BlitzCache™ v2.4. This release brings a few changes and bug fixes. Fixed a logical error in detecting the output table. Thanks to Michael Bluett for pointing that out. Sorting by executions per second finally works. Thanks to Andrew … Continue reading → Coupon code ...

Announcing Our New All-in-One Download Pack 30 Oct 2014
We give away a lot of stuff – scripts, setup checklists, e-books, posters, you name it. But we kept hearing a theme from folks: “Wow, I’ve seen one of your tools before, but I had no idea there were so … Continue reading → Coupon code RSSREADER gets you 15% off any of ...

What Changed Our Career Trajectories? 29 Oct 2014
We’re a group of specialists and teachers here at Brent Ozar Unlimited. But we didn’t start that way– we started out as engineers and developers. So what was it that changed our career trajectories? For each of us, we had … Continue reading → Coupon code RSSREADER gets ...

Preparing for the #SQLPASS 2014 Keynote 28 Oct 2014
Every year, when I attend the PASS Summit conference, I liveblog the announcements. Let’s take a quick walk down memory lane: PASS 2013 keynote announcements: SQL Server 2014 CTP2, the last preview before the official release You could deploy in-memory OLTP … Continue reading ...

What to Expect at the PASS Summit and SQL Intersections (Video) 27 Oct 2014
If you’re going to a SQL conference for the first time, join us to learn how things work. We’ll share what happens when you walk in the door for the first time, where to go after hours, what to bring, … Continue reading → Coupon code RSSREADER gets you 15% off any of our classes or ...