If you are required to use real production data to test applications, any sensitive data should be "disguised" before loading it into the development environment. The Change Data Capture feature of SQL Server captures DML changes happening on a tracked table. Arshad Ali demonstrates how this feature can be leveraged. Change Data Capture (CDC) and Change Tracking (CT) were both introduced in SQL Server 2008 for data tracking. While CDC…