Introduction to SQL Server Temporal Tables

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Explore the essentials of SQL Server temporal tables in this comprehensive conference talk. Learn about system-versioned temporal tables, their unique approach to storing time-based data, and how they enable point-in-time historical analysis of changed data. Discover the concept of temporal storage and its implementation in SQL Server through realistic examples. Gain insights into creating and importing history tables, querying temporal data, and utilizing SystemTime. Witness demonstrations on creating temporal tables, handling data modifications, and exploring alternatives. Delve into advanced topics such as displaying data in applications, tracking changes, and understanding temporal table functionality. Address questions about using temporal tables for slowly changing dimensions (SCD3), replication, and other practical applications in SQL Server environments.

Syllabus

Introduction
Welcome
Agenda
About me
Housekeeping
Temporal Tables Overview
Use Cases
Requirements
Creating a History Table
Importing a History Table
Querying a History Table
SystemTime
Demo
Create Temporal Table
Temporal Table Alternative
Data Modifications
Post Modification Script
Summary
Questions
Controls for displaying data in an application
Who made the change
Temporal table functionality
Changes in 2019
Can you use them for SCD3
Can you use them for replication
Can you use a temporal table