Product has been added to your cart.

Company News

Home
Company News

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…

How I Use the First Responder Kit

Announcing a New Live Online Class: How I Use the First Responder Kit

Last Updated November 13, 2019

Company News, First Responder Kit Updates

During the hands-on labs for my Mastering classes, when I’m answering an attendee question, this kind of thing happens a lot: Attendee: “How would I find the query causing that missing index recommendation?” Me: “Oh, good question – you can use the sp_BlitzCache @SlowlySearchPlansFor parameter. Here’s how it works.” (Does a quick demo) Attendees in…

My Annual Cyber Monday Sale is On Now!

Last Updated December 2, 2019

The time is finally here, the moment you’ve been waiting for all year: your chance to save 73-82% on my training classes and online services: Level 1: Fundamentals$295Recorded Class Season PassSQL ConstantCare®The Consultant ToolkitNormal price: $1,385Save $1,090 (79%)Buy NowLevel 2: Live Classes, No VM$995Live Class Season Pass(does not include lab VM)Recorded Class Season PassSQL ConstantCare®The…

Live Class Season Pass

What’s It Like to Have a Live Class Season Pass?

Last Updated September 15, 2019

I don’t usually post product reviews here on the blog, but Vadim Kulikov (aka BlondeDBA in Slack) recently finished all of the Mastering classes, and he took the time to write a really detailed review. Here it is, unedited: I heard some folks refer to Brent’s training as “Brent Ozar’s Full Experience”. I really like…

Mastering Query Tuning

My classes have really sucked lately, and I apologize.

Last Updated May 22, 2019

I teach my Mastering classes in a regular rotation: Mastering Index Tuning, then Mastering Query Tuning, then Mastering Server Tuning. I go 1-2-3 like that because they build on each other, and I repeat ’em over and over through the year so people can gradually make progress. I just finished another rotation, so it’s time…

BrentOzar.com is Turning 17 Years Old.

Last Updated May 8, 2019

I registered it before then, and it used to be a static HTML site, but I consider the birthday to be the first published blog post from May 7, 2002. A few fun stats: 2002 Brent: at home with a Thinkpad with a webcam module on top, reading HAL-PC Magazine 2,546 blog posts 38,614 comments…

Mastering Index Tuning

What are students saying about my latest round of classes?

Last Updated March 14, 2019

Mastering Index Tuning has a fresh set of reviews from the latest students. Levente Kalotai wrote: Absolutely loving it. The class, Brent style, everything. I have to admit, I had my reservations before the class, but boy I was wrong about it. Less than 5 minutes in the first lab anyone can see the insane…

Mastering Index Tuning

The Next Mastering Series is About to Start. Wanna Save $2,000?

Last Updated February 6, 2019

Company News, Conferences and Classes

Ever wanted to take my Mastering series of classes? I recommend that you take ’em in a specific order because each class builds on the next. If you try to parachute in out of order, you’re gonna have a bad time. The next rotation is about to start: Fundamentals of Index Tuning – Feb 13…

Brent Ozar Techorama 2018

Registration Open for My Upcoming Pre-Cons: Belgium, Dallas, Iceland, Israel, Miami, Orlando!

Last Updated February 5, 2019

I’m hitting the road this spring. Here’s where to find me in person: SQLSaturday Iceland – Your First SQL Server Performance Tuning Class – March 16 – You’re stuck with a database server that’s not going fast enough. You have a hunch that the biggest bottleneck is inside the database server somewhere, but where? In this one-day…

Erik and Tara Are Heading Out

Last Updated January 2, 2019

The rock stars. About two years ago, I realized I didn’t have the skills to grow the consulting part of the company to become a 10-employee firm, so I laid off Angie, Doug, and Jessica. This year, I made the tough decision to close the consulting side of the business entirely. I’ll be focusing on…

The 2018 Blog Posts You Commented On the Most

Last Updated December 22, 2018

Of the blog posts we published in 2018, here are the ones that got you talking the most. These comment counts are as of December 17th (writing this post a little ahead of time.) 10. SQL Server Patches for Meltdown and Spectre Attacks, Brent Ozar – 26 comments. 9. Index Tuning Week: How Many Indexes…

Pocket Square

Congratulations to the Scholarship Class of 2019.

Last Updated November 19, 2018

To celebrate the holiday season each year, we give back to those who spend the 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. This year, we’re proud to announce a new round of winners.…

PowerShell for DBAs

You read reviews before you buy training, right?

Last Updated October 23, 2018

Confession time: I love buying stuff. It’s not so much the buying as it is the comparing. I go to The Wirecutter, I read every review on Amazon, and I make little Excel spreadsheets to show differences between products. So what about when you buy database training? Do you read the reviews? If you’ve been…

Thank you, #sqlfamily, for donating to The Trevor Project.

Last Updated October 22, 2018

#SQLPass, Company News

A couple of weeks ago, we told you about how Andy Mallon’s LGBTQ Meetup was raising money for The Trevor Project, and how we’d match up to $5,000 of your donations. This weekend, you did it. You hit the $5,000 mark. I’m so proud of you. This is the caring, welcoming community that I love.…

The Senior DBA Class

Building SQL ConstantCare®: Separating Out the Videos

Last Updated October 12, 2018

When we started offering SQL ConstantCare®, our mentoring service, I wanted to make our web site as simple as practical. Too many choices can paralyze people (and a great place to read more about that is The Paradox of Choice.) To streamline your options, I just bundled all of our self-paced recorded training videos in…

Pocket Square

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

Last Updated October 31, 2018

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…

Database DevOps Featuring Microsoft SSDT

New Classes: Dashboard in a Day, Database DevOps, tSQLt, SQL Server Internals, and Avoiding NOLOCK

Last Updated July 27, 2018

We’ve got a few new goodies, and they’re 50% off for a limited time! Dashboard in a Day – A hands-on workshop using Power BI to rapidly produce great looking interactive reports and dashboards. Your instructor, Microsoft MVP Steph Locke, has a decade of BI and data science experience. Learn more and register. Database DevOps Featuring…

Great Post Erik - Book Cover

Announcing “Great Post, Erik” – A Book of Erik’s Best Work

Last Updated August 9, 2019

Erik Darling blogs a lot. Not lightweight stuff, either, but ambitious posts with a lot of demo scripts, screenshots, and detailed explanations about why SQL Server does what it does. So as he approached his 300th blog post, we decided to build a best-of book with his favorites. There’s no new content here: if you’ve…

New class survey

What Do You Want to Learn This Fall?

Last Updated July 16, 2018

New class survey We’re designing a new round of courses for the fall. Let us know what you want to learn in this short survey. After you take it, you get to see the answers, too, so you can learn what other folks wanna learn.