Month: August 2011

If You Aren’t Measuring It, You Can’t Manage It

It sounds simple and logical doesn’t it.  One could say it is common sense right?  How many of us are failing to do this simple task?  It could be things as simple as having a monitor tracking successful backups, amount for free disk space on a drive or the amount of free space in your […]

Data Warehousing with SSIS

As a DBA why would I consider attending a pre-con by John Welch at SQL Saturday 89 titled Data Warehousing with SSIS?  For starters lets look at what all the session entails. –          Laying out a framework for your ETL Logging, Restartability and Recoverability, Auditing –          Common SSIS Tasks Using FTP to Retrieve Files, Copying and Archiving Files, Executing SQL Statements, Moving Data […]