Temporal tables

Over the years, Microsoft has offered many features for tracking data changes. You may remember Change Data Capture or Change Tracking. Starting at SQL Server 2016, Microsoft provides a new powerful feature called temporal tables. Temporal tables are regular tables that are used for any desired data contention, but such tables are also supported by read-only tables that catch every change made in the source table. A big benefit of this is that creating temporal tables is transparent to applications.

The following example code shows how to create temporal tables. Let's use the Src.Products table. This table has the same structure as in previous samples, but it also works for end users of source business applications. Let's ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.