"For developers, one difficult problem in SQL Server is tracking what data has changed in a database. An even greater challenge is architecting a simple solution that doesn’t heavily impact workload performance and isn’t difficult to create, implement, and manage. So why go to all the trouble to track changes? Is tracking changes really worth all this effort? Two commonly cited examples are to support updates to a data warehouse and to support the synchronization of heterogeneous, occasionally connected systems." –Paul Randal
SQL Server 2008 introduces two new features that allow you to track changes more easily and efficiently.
In the November 2008 issue of TechNet Magazine, Paul Randal examines the new Change Tracking and Change Data Capture features and discusses the implications these features will have for database administrators.
We also have a video screencast of Paul demonstrating how you can use the new Change Data Capture feature in SQL Server 2008 to track changes in your database.
And you can read the full article and watch the video online now.