SQL Server 2008: Track Changes in Your Database

"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.

Comments (2)

  1. Anonymous says:

    196 Microsoft Team blogs searched, 100 blogs have new articles in the past 7 days. 243 new articles found

  2. Anonymous says:

    Thanks for sharing nice information, i like your post. really good work. It introduces SQL server 2008 fetures and track database changes efficiently. I found good information from
    which provides information about tracking what data has changed in a database. This tool helps to improve performance by scheduling de-fragmentation at the required time.