Company News

Portrait in T-SQL

My 11 Favorite 2019 Blog Posts

Company News
4 Comments
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…
Read More
Big tequila

Your Ten Favorite Blog Posts from 2019

Company News
2 Comments
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…
Read More
Mastering Index Tuning

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

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,…
Read More
How I Use the First Responder Kit

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

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…
Read More

My Annual Cyber Monday Sale is On Now!

Company News
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…
Read More
Brent Ozar Techorama 2018

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

Company News
0
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…
Read More

Erik and Tara Are Heading Out

Company News
30 Comments
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…
Read More

The 2018 Blog Posts You Commented On the Most

Company News
0
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…
Read More
PowerShell for DBAs

You read reviews before you buy training, right?

Company News
0
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…
Read More