SQLSaturday #523 – University of Iowa – Iowa City 2016

Hosted by SQLSaturday and University of Iowa:

Capture Changes with SQL Server’s Change Data Capture

SQLSaturday #523

Saturday, June 11, 2016 12:25 PM

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

Summary:

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

Event Follow-Up:

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

Download: Presentation Slides
Download: Demo T-SQL Scripts