Author Archives: Stephen
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
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
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
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
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.