SQLSaturday #122, Louisville

Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...

SQLSaturday #164, Cleveland

Date: August 18, 2012

Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...

SSIS 2012 Change Data Capture (CDC) Control Task

Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...

Time Zones

Why don’t we have a function like the one in this article to convert from time zone to time zone?...

Back Across the Pond

This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at...

Blueprint for consulting riches

As a business intelligence architect consultant, I have met many people out there who are as good or better than...

Changing physical locations of all DBs

I got a request this week from an application engineer. The request was to move ALL physical database files from...

Dynamic Multi-Threaded SSIS using C#

Here is a snippet of code that will assist in the dynamic ‘spin-up’ of duplicate SSIS packages.  To put it...

First SQL Server UG Meeting in Harrisburg, PA

If you work with SQL Server and live in the Harrisburg area I have some great news for you. The...

Group Think (or Groupthink)

I’ve thought about writing on this topic a couple times and was reminded of it again when I read a...