SQL Server: Change Data Capture
Learn how to capture SQL Server table data changes for downstream consumption using the Change Data Capture feature of SQL Server. This course is applicable to developers, DBAs, and architects on SQL Server 2008 onward.
What you'll learn
Of all the methods of tracking and storing changing data in SQL Server, the Change Data Capture (CDC) feature is by far the most flexible and easiest to implement. This course focuses on the implementation of CDC in SQL Server 2008 and higher, and includes topics such as configuration, querying change data, managing schema changes after enabling CDC, CDC feature compatibility, backup and restore considerations, performance tuning and optimization of CDC, and using the SQL Server 2012+ SSIS CDC components to perform ETL/ELT processing of change data into a data warehouse. The course is perfect for developers, DBAs, and architects on SQL Server 2008 onward, who need to capture SQL Server table data changes for downstream consumption.
Table of contents
- Introduction 2m
- Finding Change Table Metadata 2m
- Finding Change Table Metadata (2) 1m
- Demo: Finding Change Table Metadata 3m
- Understanding Change Table Columns 2m
- Demo: Understanding Change Table Columns 3m
- Determining Change Rows to Process (1) 2m
- Demo: Determining Change Rows to Process by LSN 2m
- Determining Change Rows to Process (2) 2m
- Demo: Custom Tracking Table for LSN Mapping 4m
- Change Row Table-valued Functions 1m
- Demo: Change Row TVFs 4m
- Determining Whether a Column Changed 2m
- Demo: Determining Whether a Column Changed 3m
- Summary 1m
- Introduction 1m
- Storage and Filegroup Considerations 1m
- Demo: Specifying Change Table Filegroup 2m
- Capture Job Configuration Options 3m
- Demo: Capture Job Configuration 2m
- Latency Considerations 2m
- Trigger Considerations 2m
- Demo: Trigger Effects on CDC 4m
- Net-Changes vs. All Changes 1m
- Limiting Capture Columns 2m
- Demo: Limiting Capture Columns 2m
- Summary 2m
- Introduction 1m
- CDC Control Task Component (1) 2m
- CDC Control Task Component (2) 3m
- Demo: CDC Control Task Configuration 5m
- CDC Source Component 2m
- CDC Processing Modes 3m
- Demo: CDC Source Configuration 5m
- CDC Splitter Component 2m
- Demo: CDC Splitter Configuration 3m
- Package Design Considerations 2m
- Summary 2m
About the author
Jonathan Kehayias is a Principal Consultant with SQLskills. He is the youngest person ever to achieve the Microsoft Certified Master - SQL Server 2008 certification and has been a SQL Server MVP for many years. Jonathan is heavily involved in the SQL community; including being the top answerer on the MSDN Database Engine forum, writing deep technical content on his blog (plus his old blog, and answering questions as @SQLPoolBoy on Twitter. Jonathan is a performance tuning expert, both SQL Se... more