The feature article on SQL Server 2008: Tracking Changes in Your Enterprise Database I wrote for the November issue of TechNet Magazine is live on the web. It also includes a 5 minute long screencast I recorded where I demo the change data capture feature.
You can get to the article at http://technet.microsoft.com/en-us/magazine/cc987538.aspx. The topics covered are:
- The need for tracking changes
- Tracking changes in SQL Server 2005
- Change tracking in SQL Server 2008
- Change data capture in SQL Server 2008
It's written around 2-300 level and presents a good overview of both features, as well as a comparison between them. It's written for DBAs and ITPros so does not go into depth on how to program with either feature.
Check It Out!
Checkout my previous TechNet Magazine articles and Q&A columns at https://www.sqlskills.com/blogs/paul/category/TechNet-Magazine.aspx.
Enjoy!