Archives: January 2012
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
The theme is: Deciding that… Read more
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