Brent Ozar
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. Las Vegas, US. He/him.
Brent Ozar's Training Days
Mastering Index TuningSQLBits 2020
You need to speed up a SQL Server app, but you only want to make index changes. You don’t want to buy hardware, change SQL Server, or change the code. You need to get creative, fast.
Expert Performance Tuning for SQL Server 2016 & 2017SQLBits 2018
Your job is making SQL Server go faster, but you haven’t been to a performance tuning class since 2016 came out.
Expert Performance Tuning for SQL Server 2016 & 2017SQLBits 2018
Your job is making SQL Server go faster, but you haven’t been to a performance tuning class since 2016 came out.
Performance Tuning When You Can't Fix the QueriesSQLBits 2015
Your users are frustrated because the app is too slow, and you have to fix it. Brent Ozar will share his proven methodologies to tune with indexes, SQL Server settings, and hardware.
Performance Tuning When You Can't Fix the QueriesSQLBits 2015
Your users are frustrated because the app is too slow, and you have to fix it. Brent Ozar will share his proven methodologies to tune with indexes, SQL Server settings, and hardware.
Performance Tuning When You Can't Fix the QueriesSQLBits 2015
Your users are frustrated because the app is too slow, and you have to fix it. Brent Ozar will share his proven methodologies to tune with indexes, SQL Server settings, and hardware.
Performance Tuning When You Can't Fix the QueriesSQLBits 2015
Your users are frustrated because the app is too slow, and you have to fix it. Brent Ozar will share his proven methodologies to tune with indexes, SQL Server settings, and hardware.
Performance Tuning When You Can't Fix the QueriesSQLBits 2015
Your users are frustrated because the app is too slow, and you have to fix it. Brent Ozar will share his proven methodologies to tune with indexes, SQL Server settings, and hardware.
Performance Tuning When You Can't Fix the QueriesSQLBits 2015
Your users are frustrated because the app is too slow, and you have to fix it. Brent Ozar will share his proven methodologies to tune with indexes, SQL Server settings, and hardware.
Virtualization, SANs, and Hardware for SQL ServerSQLBits 2014
When you're the one who has to plan, buy, set up, and troubleshoot production SQL Servers, you need to know about hardware, SAN storage, SSDs, virtualization, and more. Microsoft Certified Master Brent Ozar will give you confidence on tough topics.
Brent Ozar's Sessions
"But It Worked in Development!" 3 Hard Performance ProblemsSQLBits 2018
You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
Easy Performance Tuning: an Intro to Wait StatisticsSQLBits 2015
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.
Cool Story, Bro: The DBAreactions Guide to SQL Server 2014SQLBits 2015
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 DBAreactions.com, for a sarcastic, funny look at SQL Server 2014's "features" and bugs.
How to Pick SQL Server HardwareSQLBits 2014
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 the SQL Server Engine ThinksSQLBits 2014
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.
Watch Brent Tune QueriesSQLBits 2014
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.
Virtualization and SAN Basics for DBAsSQLBits 2010
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.
SQL Server Storage - 1,000GB LevelSQLBits 2010
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.
T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The StigSQLBits 2009
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.
Using Perfmon and ProfilerSQLBits 2009
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.
300-Level Guide to Career Internals: Planning Your CareerSQLBits 2020
Isn't it awkward when someone asks you, "So, where do you see yourself 5 years from now?" Brent Ozar will share how he analyzed the data job market to build his career path.
500-Level Guide to Career Internals: Building a BrandSQLBits 2020
If you want to work for yourself, you need to be able to sell yourself. I know, I hate it too - it feels gross when I write it that way. I'm Brent Ozar. You recognize my name, that's why you wanna learn this from me.
Deadlocks: Lets Do One, Understand It, and Fix ItSQLBits 2020
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.
"But It Worked in Development!" 3 Hard Performance ProblemsSQLBits 2018
You've been performance tuning queries and indexes for a few years, but lately, you've been running into problems you can't explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation?
Easy Performance Tuning: an Intro to Wait StatisticsSQLBits 2015
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.
How to Pick SQL Server HardwareSQLBits 2014
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 the SQL Server Engine ThinksSQLBits 2014
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.
Watch Brent Tune QueriesSQLBits 2014
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.
Virtualization and SAN Basics for DBAsSQLBits 2010
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.
SQL Server Storage - 1,000GB LevelSQLBits 2010
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.