Pinal Dave is a Microsoft SQL Server MVP and a prominent
expert on SQL servers. He has written over 1000 articles on the subject on his
http://blog.sqlauthority.com . He is a dynamic and proficient Principal
Database Architect, Corporate Trainer and Project Manager, who specializes in
SQL Server Programming and has 7 years of hands-on experience. He holds a
Masters of Science degree and a number of certifications, including MCDBA and
MCAD (.NET). He was awarded Regional Mentor for PASS Asia.
Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relational 'change tables' rather than in an esoteric chopped salad of XML. These change tables contain columns that reflect the column structure of the source table you have chosen to track, along with the metadata needed to understand the changes that have been made. Pinal Dave explains all, with plenty of examples in a simple introduction.… Read more