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