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

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

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

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

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

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

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

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

2010 Goals Review

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

XQuery for the Non-Expert – Substring() Function

Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Within the...