Thanks for attending Time Travelling Data at TechBash 2023!
Time Travelling Data: A Quick Overview of SQL Server Temporal Tables
Often, customers will ask what the data looked like on a particular date, and you might have built complex triggers and procedures to track that history. But SQL Server and Azure SQL already have a built-in solution, and it’s straightforward to use. In this session, you will learn what Temporal Tables are, key scenarios for 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.
Learning Objectives
- 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