SQL Server 2012 AlwaysOn & A Thorough Setup

It’s surprisingly easy to set up the new AlwaysOn features. I’ve done it on VMs running on my laptop, from...

Let’s Talk

I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...

Avoiding Bad Query Performance

There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:

That’s certainly not...

Meme Monday: Deadlines

Tom LaRock (blog|twitter) has assigned an interesting topic for Meme Monday this month, working with deadlines.
Some people hate deadlines. Some...

Learning, Networking & Wine

Let’s say, you want to spend a couple of days learning about SQL Server. You also want to spend some...

Tech on Tap v1.1 Wrap-up

The first ever Tech on Tap event was held on Saturday, January 27th, 2012 at the Stone Cellar Brewpub in...

Execution Plans, What Do I Look At?

The question came up, what are the top 3-5 things that you look at in a query. I realized then...

Deadlock Monitoring

There are four different ways you can get information about deadlocks in your system. These are:
traceflag 1204traceflag 1222trace eventsextended eventsFor...

Stop PIPA & SOPA

I’m not going to black out my blog, because, let’s face it, who’s going to notice? But for all six...

Database Backups: Things You Need To Do Now

I want to say a few things about database backups that you need to know.
Wait a minute, haven’t you written...