One of my most popular sessions is Watch Brent Tune Queries. I’ve updated it every year, tuning different queries, showing new tools like SentryOne’s Plan Explorer, StatisticsParser.com, SSMS’s plan comparison, and SSMS 2017’s new scenario evaluation tool. One hour is never enough – there’s so many tricks and tips I want to show in action,…
On my Poland trip, I sat down with Kamil Nowinski and Damian Widera to talk about how I got started with presenting, why I don’t use PowerShell (but you should), how sp_Blitz ended up on Github, my work/life balance, the Microsoft Certified Master exam, and a lot more. The whole thing is fully transcribed, so…
SQL Server Integration Services has changed a lot over the last decade, but one thing has remained the same: Andy Leonard has been the go-to name in the business. I’m excited to announce that we’ve partnered with Andy for online delivery of his master-level course, Expert SSIS Training. Here’s the abstract: Data integration is the…
Going to the PASS Summit in Seattle this year? Join me & Erik Darling on Tuesday, the day before the conference, at our pre-con session, Expert Performance Tuning for SQL Server 2016 & 2017. Your job is making SQL Server go faster, but you haven’t been to a performance tuning class since 2016 came out….
Now that SQL Server ships with R, and you can use R code in T-SQL, your managers might be asking, “Hey, can you start doing some analysis and visualization?” Good news! We’ve got a new class for that. Come learn the fundamentals of analysis & machine learning in R, and how to operationalize your work….
You’re confident writing queries to get the data you want, and you’ve been doing it for a couple of years. You’ve taken our free T-SQL Level Up class, mastered tally tables and windowing functions, but what else is there? In this class with T-SQL maestro Erik Darling, you’ll learn tricks to take your queries to…
I had a great time in San Diego over the last couple of weeks teaching classes. I’d love to be able to have every training class where we can do breakfast & lunch outdoors! Buuut, we gotta move classes around, so here’s our upcoming lineup: Performance Tuning (4 days, $3,995) – You’re a developer or DBA…
We’ve been selling training videos for a few years now, and we’ve figured out that we have two kinds of buyers: Price-sensitive short-term customers – who are often paying out of their own pocket because their company won’t pay, and they want to learn as much as they can in a short period of time…
When we launched our self-paced online training classes, we packaged them as focused courses that addressed a single pain point like: How to Tune Indexes and Speed Up SQL Server How to Read Query Plans DBA’s Guide to High Availability and Disaster Recovery Virtualization, SANs, and Hardware for DBAs You paid a fixed price for the…
With fifteen years of blog posts, we’d accumulated a lot of junk around here. Recently we cleaned out a lot of the trash – old personal posts about boring stuff – and categorized the remaining ~2k posts to make it easier to find stuff by topic. Now, at the top of BrentOzar.com, when you hover…
Last year, we gave dozens of amazing people a helping hand so they could improve themselves – and the world around them. I was really touched by the heartfelt thanks we got – and yep, tears were shed. (On both sides of the screen.) So it’s time to do it again. You work with Microsoft SQL Server…
Since the dawn of man, people have struggled with sharing execution plans with each other for performance tuning. Now, it’s easy. First, get yourself a plan: Get the estimated execution plan by hitting control-L or clicking Query, Display Estimated Plan. Right-click on the graphical plan, and click View XML. Copy all of that. Or even…
I always wanna be honest with you, dear reader, and let you see how running a lil’ consulting shop goes. It’s been fun sharing a lot of our happy growing moments along the way. This one, though, is a lot less fun to share. Yesterday, we had to let go of Angie, Doug, and Jessica. The…
During our very first training class, we showed the students how we use SET STATISTICS IO ON to get the number of logical reads performed on each table in a query, and then sum ’em up to see the query’s overall impact. It’s kind of a painful, manual process. Sitting in the back row of the…
Tara Kizer is starting a new job today, and I’m proud to say that it’s with Brent Ozar Unlimited. You might know Tara from: @TaraKizer on Twitter Her wildly prolific participation in the SQLTeam forums and her blog there as well Her performance tuning chapter in the Tribal SQL book Her 9 years as a Microsoft MVP…
When we started the company a few years ago, we had no idea what we were in for. We had to: Come up with a product Build a consistent, repeatable process Hire the right people to help perform that process Train them how to do the process Scale it up bigger Build training classes for…
Thanksgiving is the perfect day for us to give back to the community that has given so much to us. Our SQL Server Training Scholarship program applications were open to folks anywhere in the world working with SQL Server for foundations, non-profits, charities, or other similar companies making a real difference in the world today. We…
Brent says: remember a couple months back when we announced that we were hiring a SQL Server Triage Specialist? We’re really proud to welcome Angie Walker to our funky little medical team. When you bring us in for a SQL Critical Care®, Angie might be the first person you work with to make sure the server’s in a…
You work with Microsoft SQL Server – maybe as a developer, report writer, analyst, sysadmin, or DBA. You want to learn more about how to make it faster and more reliable. But your company can’t afford training. Maybe it’s a charity that needs to save every dollar to make a difference in the lives of others. Or maybe…
Four years ago this month, we turned this blog into a consulting company. We’ve had so much fun over the last few years, and we’re really proud of what we’ve built: Over 500 SQL Critical Care® patients Thousands of training video customers Thousands of in-person training attendees at dozens of classes and pre-cons Hundreds of…
