Level: Intermediate to Advanced

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

In this session, Kevin will talk about Change Data Capture (CDC) terminology and configuring a database for Change Data Capture. He will show you how to read CDC log tables and CDC code samples while discussing CDC and SQL Server Agent jobs, and the use of CDC versus database triggers (and where triggers are still needed). Also, the impact of CDC on the transaction log and system performance will be explored. Finally, Kevin will talk about how to deal with schema changes, performance tuning, and using CDC in an ETL (Extract-Transform-Load) environment with SQL Server Integration Services.

You will learn:

• How the database engine in SQL Server can be configured to automatically capture changes to rows in a table
• Performance differences between Change Data Capture and other forms of audit-trail logging (such as triggers)
• How CDC might be used in a data warehousing/ETL scenario