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
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