This presentation introduces temporal tables as implement in SQL Server beginning in version 2016.

Slide deck: PowerPoint (850KB) or PDF (612 KB).

Demo Scripts: ZIP (3 KB)

Topics addressed in this session

• The “old” ways of capturing change data
• How temporal tables can be used
• How temporal tables work
• Creating temporal tables
• Querying temporal tables
• Miscellaneous topics (transaction, schema changes, AT TIME ZONE, performance, indexing, archiving or purging history, catalog views)

Presentation History:

• DevSpace, Huntsville, Alabama, October 12, 2019