Tracking Data Transformations Using Temporal Tables by Thomas Lane, PhD
YouTube Viewers YouTube Viewers
222 subscribers
68 views
0

 Published On May 1, 2019

--Thomas Lane's presentation for FoxPass in 2019
--Recorded live to Twitch
--Apologies for the video glitch halfway through the presentation - new hardware woes!


A little bit about Thomas's discussion:
"Along with change tracking and change data capture, Microsoft has introduced a new method for tracking data changes within its databases called Temporal tables. Microsoft introduced temporal, or system-versioned, tables in SQL Server 2016 as a new database feature. A temporal table truly introduces two tables into the mix: one for current data and another for historical data. This talk will show how the feature is implemented and used along with a discussion on the common usage for temporal tables. Scripts will be explored for the automation of the creation of temporal tables along with its use in data warehousing."

show more

Share/Embed