The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in Appleton, WI. If you weren’t there, well, you missed it. Notice that keyword in that earlier sentence, Brewpub. Yes, the Tech on Tap events (and there will be more) are… Read more

The question came up, what are the top 3-5 things that you look at in a query. I realized then that I hadn’t really written them down. There are some areas that let me know pretty much immediately where problems lie within a plan. You don’t necessarily know the answer… Read more

There are four different ways you can get information about deadlocks in your system. These are:

• traceflag 1204
• traceflag 1222
• trace events
• extended events

For years I’ve been pushing traceflag 1222 as the best of the lot. Well, that’s over. I’ve been learning more and more about extended events and… Read more

I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six of you who read this (and, of course, you Mom), I do want to point out that these are horrific bad bills. They are sponsored by Democrats and Republicans, so… Read more

Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like you.

We have a tagging theme started by Ted Krueger (blog|twitter) who I also used to like.

The theme is: Deciding that… Read more

I want to say a few things about database backups that you need to know.

Wait a minute, haven’t you written about backups before?

Why, yes. Yes I have.

Aaand… you’re doing it again because?

Have you noticed the shocking number of questions that come up on SQL Server Central… Read more