Change Tracking: An near bullet proof ETL synchronization control

CACTUSS North speaker this month will be Mike Byrd.
Change Tracking:  An near bullet proof ETL synchronization control

Abstract:  Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.

Bio: Former rocket scientist, retired USAF fighter test pilot; now a database geek. Former CTO for Texas Windstorm Insurance Association (9 years) and now part-time SQL Server consultant for several companies in greater Austin, TX area. Expertise is performance tuning. 

The meeting starts at 5:30PM CST with food and a QA session. The main presentation is at 6:00PM. 
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300

Follow @CACTUSS_SQL for the lastest information.

Upcoming Speakers: