Company News

Unknown person of dubious quality

Your Ten Favorite Blog Posts from 2020

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

Want Your Own Private Conference?

Company News
Your team has been reading my blog, watching my free public streams, and using the First Responder Kit scripts for years. They’ve gone as far as they can go on their own, learning from Google, and now they’re ready for the next level. I can bring the conference to you – except way better than a…
Read More
Unknown person of dubious quality

Free Upcoming Live Classes

Company News
2 Comments
So, we’re still under lockdown, huh? I see. Well, I guess I’ve got no choice but to keep y’all busy. Let’s get together for some free live classes: May 12 (Tues) Noon Eastern: The New Robots in SQL Server 2017 and 2019 – You’ve been hearing about all these robots that are coming to take…
Read More
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