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