TechNet Magazine Blog

The official blog of TechNet Magazine

SQL Server 2008: Track Changes in Your Database

SQL Server 2008: Track Changes in Your Database

  • Comments 2
  • Likes

"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
  • 196 Microsoft Team blogs searched, 100 blogs have new articles in the past 7 days. 243 new articles found

  • 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 http://www.sqlservermonitoring.net/
    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.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment