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...

August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture

August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...

Using SSIS lookup transformation editor with millions of rows

If you are using a SSIS lookup transformation editor and the reference dataset is large (millions of rows) and you...

I am a Big Bro

The first time I did any volunteering work for PASS was last year at the Summit. I enjoyed doing it....