One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems. In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your ETL workflows: Brute Force Log shipping/Read Only standby Rowversion datatype Change Tracking Change Data Capture Temporal Tables
One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems.
In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your ETL workflows: