embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Speaker:

Mike Byrd

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 and USAF Fighter Pilot — now a SQL Server geek. Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and IT Director for insurance company, Currently senior database consultant for several Austin companies; free lance tech writer for Solarwinds. Ideal job is sproc and query performance tuning and/or TSQL training. Presented TSQL Precon at Dallas SQL Saturday 2015. Have presented several TSQL classes to private businesses including one Advanced TSQL class to Solarwinds Corp office, Austin, TX last April 2016.

Recorded At:

SQL Saturday Houston 2016

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>