Product has been added to your cart.

Company News

Announcing My 2021 Black Friday Sale Bundles

Last Updated September 16, 2021

You’re a database professional who wants to up your game. You’ve been stuck at home this year, and next year isn’t looking much better. You can’t attend in-person training classes, but you desperately need the training. You’re facing bigger and bigger data problems. You’re dealing with more and more queries. The queries are getting more…

Pocket Square

Congratulations to the Scholarship Class of 2021.

Last Updated October 16, 2021

To celebrate the holiday season, we give back to those who spend their entire year giving back in their own communities. We go looking for data professionals who make a difference, and we try to make a difference in their lives too. The scholarship program makes the heart part happy. This year, we’re proud to…

This is the Last Year You Can Buy a Live Class Season Pass.

Last Updated October 11, 2021

When you buy my Live Class Season Pass, you can attend all of my live online training classes for a year straight, plus watch the recordings. It’s an excellent deal: go to your manager just once, get approval just once, and then spend the entire year learning how to master SQL Server. You don’t have to…

Free Classes Start Next Week. Register Now.

Last Updated October 11, 2021

This month & next, I’m going to teach you the fundamentals of SQL Server database performance tuning, live, for free. The first class is my How to Think Like the Engine class. It’s already free online in both video and blog post formats, but this fall I’m updating and expanding it to a 3-hour version.…

Pocket Square

Free Training Classes for Those Who Give Back: Announcing our 2021 Scholarships

Last Updated October 16, 2021

You work at a charity or non-profit, helping them make a difference with data. Maybe you write reports to help fundraisers do a better job of raising money to find a cure for a disease. Or maybe you’re a developer at a non-government organization whose mission is to speak for those who can’t speak for…

Office Hours - ask me anything.

Upcoming Office Hours: Get Your Questions In Now

Last Updated July 27, 2021

From time to time, when my incredibly busy (cough)vacation(/cough) schedule permits, I do a live Office Hours stream where I take your questions and answer ’em live. I’m going to do a couple of them this week, but I’m going to do them disconnected. I’ll be recording them on the road – Erika and I…

Announcing My 2021/2022 Training Class Schedule

Last Updated June 18, 2021

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…

Contest: My Favorite Caption Wins a Live Class Season Pass

Last Updated May 24, 2021

Company News, Humor

Update 2021-05-24: the contest is over, and the winners are here. Let’s have a few laughs this week. In the comments, write a caption for this: Prizes: My favorite caption overall wins a Live Class Season Pass Runners-up get both a Recorded Class Season Pass: Mastering Classes and Recorded Class Season Pass: Fundamentals Classes Honorable…

Announcing Fundamentals Week: May 10-14, $295

Last Updated April 27, 2021

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…

Sale Closes Wednesday: Save 75% on My Training Classes, and the EU/UK Can Buy Too.

Last Updated March 27, 2021

Good news, party people: we’re finally selling to the EU/EEA/UK again! To celebrate, during March you can use coupon code Happy20th to save 75% off my Live Class Season Pass, Recorded Class Season Pass Fundamentals, or Masters recordings, or any of my online classes. You can also buy my classes now in Euros, GBP, or…

Our Monday Links Email is 10 Years Old.

Last Updated March 21, 2021

I’ve been celebrating the 20th anniversary of BrentOzar.com, but it just so happens that this year marks another fun anniversary. Ten years ago, way back in 2011, I wrote: You’re overworked. You don’t have the time to sit around reading blogs, keeping up on the latest industry news, and reading web comics. That’s where we…

How I Worked Toward GDPR Compliance: The Really Long Story

Last Updated March 12, 2021

BrentOzar.com is 20 years old, so I’m spending 20 days reflecting. Yesterday, I wrote about how my online classes are available to Europeans now, and today I’m going to talk about why that was a problem for a while, and how I solved it. The short story is that I outsourced the whole thing to…

Wow: BrentOzar.com is 20 Years Old.

Last Updated March 10, 2021

My first avatar, by Jin Wicked In 2001, I was a developer, and I liked to write. I’d had web sites for a number of years, but in 2001, I decided to switch from wickedlife.com (archive) over to BrentOzar.com. I wanted a domain name that would more appropriately reflect my interests as they changed over…

Save 75% on My Training Classes – Europeans Too!

Last Updated March 27, 2021

Good news, party people: we’re finally selling to the European Union, European Economic Area, and the United Kingdom again! To celebrate, during March you can use coupon code Happy20th to save 75% off my Live Class Season Pass, Recorded Class Season Pass Fundamentals, or Masters recordings, or any of my online classes. You can also…

It’s March. We’re still quarantined. Let’s do some free classes for Europeans.

Last Updated March 10, 2021

Last year, during the first few months of quarantines, I ran free training classes to help y’all pass the time and raise your skills. Thankfully, I don’t need to wear this during the online classes. It’s March 2021, and so many of us around the world are still stuck indoors, not going into work, not…

Eyes up here, kid

Free Webcast: Help! My SQL Server Maintenance is Taking Too Long!

Last Updated January 22, 2021

Backup and Recovery, Company News, Index Maintenance, Production Database Administration

“Time for a smoke break.” You manage growing SQL Server databases with shrinking nightly maintenance windows. You just don’t have enough time left each night to do the necessary backups, corruption checking, index maintenance, and data jobs that your users and apps want to run. Cloud storage isn’t helping the problem, either. Stop playing Tetris…

Your Ten Favorite Blog Posts from 2020

Last Updated December 31, 2020

The most popular posts this year were when I ran my Fundamentals classes for free throughout the year. I ran a different class per month, and posted signups and videos here on the blog. I’m setting those aside, though, because they’re not evergreen: they’ve since disappeared since I only ran ’em free for a limited…

Announcing a New Live Online Class: Fundamentals of TempDB

Last Updated November 30, 2020

Company News, TempDB

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…

Why I Teach Training Classes on Weekends (the next one starts Friday)

Last Updated November 30, 2020

Company News, Conferences and Classes

You have a day job. And your day job comes with two big problems. Problem #1: it’s hard to pay attention during the week. Your calendar has tons of meetings scheduled for the foreseeable future, and you can’t just reschedule them whenever you want. Even when you’re not booked in a meeting, people are constantly…

Want Your Own Private Conference?

Last Updated July 8, 2020

Your team has been reading my blog, watching my free public streams, and using the First Responder Kit scripts for years. They’ve gone as far as they can go on their own, learning from Google, and now they’re ready for the next level. I can bring the conference to you – except way better than a…

Menu