Session Description:
Capture Changes with SQL Server’s Change Data Capture
Speaker(s): Wylie Blanchard
Duration: 75 minutes
Track: Application & Database Development
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.
Accompanying Materials:
- [Demo] – T-SQL-Demo-for-Presenation-Capture-Changes-with-SQL-Server-Change-Data-Capture_SQL_Saturday_Iowa_20160611.pdf
- [Powerpoint] – Presenation-Capture-Changes-with-SQL-Server-Change-Data-Capture_SQL_Saturday_Iowa_20160611.pdf
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event was held on Jun 11 2016 at University of Iowa – University Capitol Centre, 201 S Clinton St, Iowa City, Iowa, 52240, United State