Author Archives: Stephen

MERGE in SQL Server 2008

MERGE!  You’ve arrived just in time to help me with my ETL operations. Introduced in SQL Server 2008, MERGE lets one update one table by inserting, updating, or deleting fields as appropriate based on a join with another table.  I … Continue reading

Posted in T-SQL | Comments Off on MERGE in SQL Server 2008

What, it’s December?

Well, so much for getting those November posts in. How do people make the time to do this? Still working on the MERGE post, finding some more interesting things about that SQL command, worth writing about. Here’s hoping it happens … Continue reading

Posted in Personal | Comments Off on What, it’s December?

SSIS Variables as Expressions Gotcha

SSIS work lesson of the morning:  don’t forget to set the EvaluateAsExpression property to True on your variable when you have an expression to represent the variable value. I had three variables representing similar SELECT statements to be used in … Continue reading

Posted in SSIS | Comments Off on SSIS Variables as Expressions Gotcha

Why I Write Software

I’m going to start this blog out with a story I wrote describing one of my primary motivations to write software, which is to make life easier. While I work primarily in the database arena now, I was a developer … Continue reading

Posted in Personal | Comments Off on Why I Write Software


Welcome to my blog, wherein you will find thoughts about my professional aspirations, activities, failures, and successes, and a few personal notes thrown in along the way.

Posted in Uncategorized | Comments Off on Welcome