Data and Analytics, Fast Focus

W09 Fast Focus: Time Travelling Data

March 18th, 2026

1:30pm - 1:50pm

Level: Introductory

Chad Green

Senior Systems Architect

Jasper Engines & Transmissions

Often customers will ask what the data looked like on a particular date and you might have built completed triggers and procedures to track that history. But SQL Server and Azure SQL already have a solution built-in, and it's straightforward to use. During this quick overview, you will understand what Temporal Tables are, the key scenarios around their use, and how to use built-in query syntax to retrieve the values of database records at a point in time. We will also look at how Entity Framework Core makes this even easier now with Temporal Table support.

You will learn:

  • Understand the key scenarios around the use of SQL Server temporal tables
  • Understand how to get started using temporal tables
  • Understand best practices and limitations of temporal tables