/ Database / SQLSaturday #523 – University of Iowa – Iowa City 2016

SQLSaturday #523 – University of Iowa – Iowa City 2016

Hosted by SQLSaturday and University of Iowa:

Capture Changes with SQL Server’s Change Data Capture

Presented by Great Tech Pros’ Wylie Blanchard


SQLSaturday #523

Saturday, June 11, 2016 12:25 PM

University of Iowa – University Capitol Centre, 201 S Clinton St, Iowa City, Iowa, 52240



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. Every SQL DBA and Developer utilizing SQL Server 2008/2012/2014 will benefit from this presentation.

Duration: 75 minutes

Track: Application & Database Development


SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on Jun 11 2016 at University of Iowa – University Capitol Centre, 201 S Clinton St, Iowa City, Iowa, 52240, United States


Speaker Bio:

Wylie Blanchard

SQL Server Consultant, Great Tech Pros

Great Tech Pros' Wylie Blanchard at SQL Saturday Iowa City 2016
SQLSaturday #523 Iowa City 2016 Slides & Demo ↓

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 of 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. Learn more about Wylie at: www.WylieBlanchard.com.


Event Follow Up:

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


Download: Presentation Slides
Download: Demo T-SQL Scripts