

Register for
Temporal Tables and Change Data Capture in SQL 2016
Feb 13 @ 10AM
Free Webinar: Temporal Tables and Change Data Capture in SQL 2016
Join Signzilla trainer and Expert Instructor Charles Hyman for a 2-hour complimentary webinar on Temporal Tables and Change Data Capture in SQL Server 2016.
Tuesday, 2/13/2018 @ 10am
SQL Server 2016 introduced support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time, rather than only the data that is correct at the current moment in time.
Real data sources are dynamic and more often than not business decisions rely on insights that analysts can get from data evolution.
Use cases for temporal tables include:
-
Auditing all data changes and performing data forensics when necessary
-
Reconstructing state of the data as of any time in the past
-
Calculating trends over time
-
Maintaining a slowly changing dimension for decision support applications
-
Recovering from accidental data changes and application errors
Agenda:
-
Creating System-Versioned Temporal Tables
-
Working with Memory-Optimized System-Versioned Temporal Tables
-
Modifying Data in a System-Versioned Temporal Table
-
Querying Data in a System-Versioned Temporal Table
-
Temporal Table Usage Scenarios
-
Enable Change Data Capture for a Database
-
Administer and Monitor Change Data Capture
-
Working with Change Data Using CDC with SSIS
About the Company
Signzilla Training is based in Effort, Pennsylvania, with courses offered at convenient locations near major metropolitan areas, custom training on site at your own organization,
as well as fully online.

About Mr. Charles Hyman
Register NOW to win an Amazon Fire HD 8