Create Your Own SQL Server Server Roles

So you’ve heard the buzz by now –  SQL Server Denali is now available in a Community Technology Preview. This was announced, released and handed out in DVD form at the SQL PASS Summit this past week. I just got the chance to install it and I played with one feature that I could see … Read more

Linked Server Query Running Slow?

Is your SQL Server Linked Server Query running slow? Check your permissions. Maybe this is old news to you but it wasn’t for me –> It was a good day. We had finally migrated onto brand new hardware (and saw a 250% improvement in run times of most warehouse jobs). I had finally cleaned up … Read more