Product has been added to your cart.

Company News

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…

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…

Unknown person of dubious quality

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…

And it looks bad even in shades.

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…

Unknown person of dubious quality

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…

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…

Brent Ozar Unlimited coffee mug and hat

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…

Unknown person of dubious quality

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

Company News, Conferences and Classes

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,…

Live Class Season Pass

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

Last Updated April 7, 2020

Company News, Conferences and Classes

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…

How about a nice cup of Standard Edition?

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…

Portrait in T-SQL

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…

Big tequila

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…

Mastering Index Tuning

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

Last Updated December 20, 2019

Company News, Conferences and Classes

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,…

SQL ConstantCare

New Multi-Server Emails for SQL ConstantCare®

Last Updated November 23, 2019

Company News, SQL ConstantCare

With our SQL ConstantCare® service, you install a service that polls your SQL Servers once a day, and then we send you a daily email telling you the most important tasks to perform on that server to make it faster and more reliable. We’re all about minimizing the amount of emails you get from us…