For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed, and deleted records means the difference between doing an expensive truncate-and-reload operation versus a smaller, faster incremental load. SQL Server change tracking, a feature first introduced in SQL Server 2008, allows detection of changed data – including inserts, updates, and deletes – in tables monitored by change tracking. Change tracking is a compelling tool for many change detection purposes, but is of particular interest in enterprise data warehouse scenarios, where accurately detecting new and changed records is critical to accuracy and performance.
On Thursday, March 3rd, I’ll be demonstrating the use of change tracking for data warehouse loads in a free webinar. In this session, I’ll cover the initial setup of change tracking at the database level, how to enable a table for change tracking, and how to use change tracking functions for delta detection. The webinar is free, but space is limited. You can register for the webinar here.