Christian Allaire

I have been developing applications on SQL Server for the last 12 years. After a few years in web development, I transitioned to BI and ETL. I specialize in SSIS and data integration which to me has always been the most interesting part of any project. I also have a few years’ experience on Informatica. My work experience includes working on many large scale projects, mostly in the banking, insurance and retail industry. I am presently a freelance developer which I find very rewarding because of the opportunities to be in contact with people in different sectors of the industry. Every new project is for me an opportunity to discover new approaches and to diversify my experience.

Articles: 1

Database Design

Using Hashbytes to track and store historical changes for SQL Server data

Change Data Capture (CDC) is a fundamental part of ETL especially in a data warehousing context. This allows you to capture changes as they are made and could be used to create historical data changes. A way to achieve this is through hashing algorithms.

Christian Allaire
July 19, 2012