31 Days of SSIS – Using Breakpoints (2/31)

31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS.  Today’s post is going...

31 Days of SSIS – Raw Files Are Awesome (1/31)

As I mentioned in the introductory post, I’m writing 31 Days of SSIS.  Let’s start off this series with a...

31 Days of SSIS – The Introduction

31 Days of SSIS
Last year, Glenn Berry (Blog | @GlennAlanBerry) wrote a series of posts that he called A DMV A...

Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas

Introduction

A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....

January Question: As a DBA, how do you manage your disk space?

Managing disk space is an important responsibility of the DBA, and there are many ways to perform this task. In...

MVP Award for 2011

I just received notification from the Microsoft MVP Award Program that I’ve received the MVP award for SQL Server for...

Re-Awarded MVP for 2011

I received my notice that I was renewed as a MIcrosoft MVP for SQL Server for 2011.  It's a nice...

TPC-E Benchmark Analysis by CPU Type

As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...

2010 - A Year without Specific Goals

In previous years I had set goals and even if I didn't fully achieve them, they were helpful in giving...

2010 Goals Review

I started the year with 10 Goals for 2010 and now I'll end it by looking at how many of...