PASSMN Presentation – The Creepy DBA

Last night I spoke at the PASSMN August user group meeting.  The topic was The Creepy DBA and how you...

RAID server configuration and disk amounts

Choosing the optimal amount of disks for a RAID server configuration and block sizes can be a challenge.
Typical questions from...

SQL MCM Training – Day 9

Today Jonathan was talking the whole day about Consolidation and Virtualization. There
were again a lot of new concepts, and new...

TSQL Sudoku

I am a big Sudoku fan.  Typically if I need a break, I will break out a Sudoku puzzle from any of a number of different sources (Websudoku, Android...

TSQL Sudoku

I am a big Sudoku fan.  Typically if I need a break, I will break out a Sudoku puzzle from...

Writing Your Resume

There’s a  lot of info out there about putting together a resume, and I probably can’t add a lot, but...

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

Basic Computed Columns

I ran into an issue recently with a computed column, which I’ve rarely used, so I investigated them and wrote...

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