I will be presenting Change Data Capture, Incremental ETL, and SSIS 2008 to Philadelphia Code Camp 2008.2 Saturday, 17 May 2008! The good folks in Philadelphia always do a great job with Code Camps and the attendance numbers are growing to reflect that! They're sold out again. Great job! :{> Andy

I'll be in Kansas City next week doing some SSIS training. I don't think I've ever been to KC so I'm looking forward to the trip! When I found out I would be in town, I dutifully contacted the Kansas City SQL Server Users Group to see if they were having a meeting. When traveling I like to check out Users Groups to see what other folks are doing ...

Introduction  This post is part of a series of posts on ETL Instrumentation. In Part 1 we built a database to hold collected SSIS run time metrics and an SSIS package to deomnstrate how and why we would load metrics into the database. In Part 2 we expanded on our database and the SSIS package to annotate version metadata, manage error ...

The tune to a Bush song is running through my head as I type this... the band, not the president - although imagining the President singing the song is an interesting brain-stretch. It's a fact of IT life that everything scales. Some successfully, even. Problems start when things do not scale successfully (or well). It happens in business. It ...

Introduction   Loading data from a data source to SQL Server is a common task. It's used in Data Warehousing, but increasingly data is being staged in SQL Server for non-Business-Intelligence purposes.   Maintaining data integrity is key when loading data into any database. A common way of accomplishing this is to ...