Company News

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…

Now Europeans Can Buy My Training Classes Too!

Last Updated December 15, 2021

Good news, party people: we’re finally selling to the European Union, European Economic Area, and the United Kingdom again! You can also buy my classes now in Euros, GBP, or US dollars, whichever currency is more convenient for you. When you click the Buy button, you get your choice of currency, and it calculates your…

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…

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

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…

Finally, You Can Buy Brent Ozar Unlimited Swag.

Last Updated June 22, 2020

When I’m doing a webcast, the same question always comes up: “Hey, how do I get one of those coffee mugs?” We used to give ’em away during our in-person live training classes, but since I stopped doing those, we needed to come up with a plan B. Now you can buy Brent Ozar Unlimited…

Attention Live Class Season Pass Holders: New Mastering Parameter Sniffing Videos Available!

Last Updated June 4, 2020

Time to get your learn on: this week’s Mastering Parameter Sniffing class recordings are already available in your account here if you’ve got a Live Class Season Pass. (What’s that? You don’t have one yet? Well, tell you what: click here and I’ll make you a special deal.) Just to give you a taste, the…

Free Upcoming Live Classes

Last Updated May 10, 2020

So, we’re still under lockdown, huh? I see. Well, I guess I’ve got no choice but to keep y’all busy. Let’s get together for some free live classes: May 12 (Tues) Noon Eastern: The New Robots in SQL Server 2017 and 2019 – You’ve been hearing about all these robots that are coming to take…

Announcing Two New Parameter Sniffing Classes

Last Updated November 30, 2020

During the quarantine downtime, I’m working on a couple of new classes that I think you’re gonna like. Both of them are 100% demos, no slides (other than introductions at the start of the day), complete with hands-on lab assignment challenges for you to solve. They’re both half off this month to celebrate the launch,…

Want SQL Server Training? Copy/Paste This Email To Your Boss.

Last Updated April 7, 2020

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals, our conference plans, maybe even how we wanted to do our first user group presentations or SQL Saturday presentations. These days: The events you wanted to…

Congrats. Y’all Raised $8,919 for Doctors Without Borders in March.

Last Updated April 1, 2020

I hate posting things on April 1, but there’s no laughing here, only cheering. During our March quarantine sale, I donated 10% of all sales to Doctors Without Borders. I’m proud to announce that y’all raised $8,919 to provide lifesaving medical humanitarian care in over 70 countries. I’m excited to see you in class. Y’all…

Register Now to Watch Brent Tune Queries Tonight (Free)

Last Updated January 30, 2020

It’s last-minute, I know, but I’m doing an online user group session for the Pensacola Data Professionals, and you’re welcome to attend online free if you like. It’s tonight at 8PM Eastern, 7PM Central, 5PM Pacific. Here’s the abstract: Watch Brent Tune Queries – Ever wonder how somebody else does it? Watch over the virtual shoulder…

My 11 Favorite 2019 Blog Posts

Last Updated December 29, 2019

Yesterday, I showed the stuff you read the most, but enough data – now, let’s talk about feelings. These were the 11 posts I remember with the most fondness, in date order. I did indeed like some of the ones from yesterday’s list a lot, but I’m going to set those aside. Erik and Tara…

Your Ten Favorite Blog Posts from 2019

Last Updated December 29, 2019

Here are the 2019 posts you visited the most this year: 10. The Silent Bug I Find in Most Triggers – Once you know how to recognize this bug, you’ll see it everywhere. I wrote the post as an interactive Azure Data Studio notebook, something I thought I’d be doing a lot in 2019, but…

Join Me in London for My SQLBits Pre-Con Workshop: Mastering Index Tuning

Last Updated December 20, 2019

I’m teaching an all-new hands-on workshop, Mastering Index Tuning. I’m taking my favorite, toughest modules of my 3-day online class and condensing them down into a 1-day workshop. You’ll learn quick, easy techniques to use the right nonclustered indexes, filtered indexes, indexed views, and columnstore indexes that will work on SQL Server 2019, 2017, 2016,…

New Multi-Server Emails for SQL ConstantCare®

Last Updated November 23, 2019