Contest: My Favorite Caption Wins a Live Class Season Pass
Update 2021-05-24: the contest is over, and the winners are here.
Let's have a few laughs this week. In the comments, write a caption for this:
Update 2021-05-24: the contest is over, and the winners are here.
Let's have a few laughs this week. In the comments, write a caption for this:
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.
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 Teachable.
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 time, and I figured that I wouldn't always be interested in the goth lifestyle, hahaha.
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 period of time.
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 first module, How Index Tuning Reduces the Blast Radius, is free to watch through this weekend:
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.
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…
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…
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…
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.
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.
Update 2021-03: We now sell our training classes worldwide here. The EU's new General Data Protection Regulation (GDPR) is a set of rules that give consumers rights about how their data is stored, used, and deleted. This step-by-step GDPR guide for managers is a great place to start understanding it, or for something a little…
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, walking people through how I use them in a tuning scenario.
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.
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 class (because that's how he rolls), Richie Rump saw that process and thought to himself, "I bet I could make that easier."
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 the public to learn the process
Scale those classes up bigger too
And along the way, solve all kinds of challenges around accounting, attorneys, sales, marketing, support, and human resources
Eagle-eyed readers may have noticed a subtle change to our site, swag, and PowerPoint templates over the last few months. Here's the evolution as seen in our company coffee mugs:
Far left, the one with the heart, is the current one, but the transition is a funny story.