/ Database / SQL Server Change Data Capture

SQL Server Change Data Capture

The Chicago Suburban SQL Server User Group and Great Tech Pros presents:

Capture Changes with SQL Server’s Change Data Capture

Tuesday, February 16, 2016 6:00 PM

DeVry University Downers Grove Center, 3005 Highland Parkway #100, Downers Grove, IL 60515


Learn how to easily capture information about data changes – inserts, deletes and updates using SQL Server’s Change Data Capture feature. Change Data Capture tracks INSERTs, UPDATEs, and DELETEs applied to your SQL Server tables, and then informs you of what changed and when it changed. In this presentation we’ll walk through the steps needed to activate Change Data Capture on your database tables and then explore how you can use Change Data Capture to understand how and why your data changed.

Speaker: Wylie Blanchard

ChiSug - The Chicago Suburban SQL Server User Group - Great Tech Pros Wylie Blanchard - 20160216
Get the slide deck and code used in the demo below. ↓

Bio: Wylie Blanchard, MCSE is an IT consultant, SQL Server professional and web strategist who enjoys helping people learn how to use technology as a tool to amplify their professional lives. He has 15 years’ experience in the IT Industry and holds several certifications in SQL and Oracle systems. He is a father of twin-girls, a gadget enthusiast and a self-proclaimed pizza connoisseur.

Event Follow Up:

Presentation slide deck and t-sql scripts used in the demonstration:


Download: Presentation Slides
Download: Demo T-SQL Scripts