Change Tracking (CT) and Change Data Capture (CDC) in SQL Server

SQL Server 2008 introduced a powerful and an efficient way to track the DML changes, know as Change Tracking(CT) and Change Data Capture (CDC). Both of them seem to be synonyms but they do have differences, making them useful in different scenarios. Lets try to understand what CT and CDC are.

Continue reading