Compiles and recompiles

I want to spend some time over the next few months looking at query compilation and the plan cache, and...

SSIS - Inferred Member Insert in Fact Table Load

Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...

Steel City SQL User Group

Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL.  I...

Announcing the upcoming Colorado GiveCamp

What is a GiveCamp?

GiveCamp is a weekend-long event where technology professionals from designers, developers and database administrators to marketers and...

Auditing SQL Logins Addendum

One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....

Calculate table size with existing data

Calculate the physical size of a SQL Server database table (data and indexes) , if rows exist . These steps present a...

T-SQL Enhancements: OVER clause

With SQL Server Denali there has been made some improvements to the OVER clause, which I wasn’t even aware of...

SQL MCM Training – Day 8

Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations.
I've already known a lot about Backup/Restores, but...

MCM Training – Day 6 & 7

My whole weekend was dedicated to MCM studying, and I've reviewed a lot of stuff that
we have learned through the...

When Do You Take a Full Backup?

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...