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…
Dear Brent Ozar Unlimited readers: thanks for following me for three great years. I’m off on a new adventure, but I hope to see you at a user group, a SQL Saturday, or a conference in the future! I’m leaving with a lot of great memories – and here are a few of my favorites…
Hey SQL Server DBAs — we’re hiring! Here’s a quick five question quiz. Give yourself one point for every ‘yes’: Have you been a database administrator for a few years? Does planning how to keep an application reliable and safe from disasters sound like fun? Do you love helping people make SQL Server go faster? Would you…
When we first started our company, we laid out our goals in a shared Google Doc. We wrote about what we wanted to do, how we wanted to treat our employees and customers, and the growth numbers we wanted to achieve. One of our original goals was to hire one consultant per year. In 2012, it…
Occasionally people ask me if I’m responsible for the cool artwork on our site. I wish I had those kind of skills! The artist behind the artwork on our website is the one and only Eric Larsen. Eric’s been great to work with: he doesn’t laugh at our crazy ideas, he makes thoughtful suggestions, and he’s…
Three years ago this month, we turned this blog into a consulting company. This year, we’re … well, we’re still not adults. It’s been an incredible three years. Sure, it feels just “normal” now, but when we look at the numbers, suddenly it feels like a big deal compared to where we were in 2011:…
