SQL Server temporal tables are a relatively new introduction to the SQL Server stack, representing a unique way to store temporal (time-based) data. These system-versioned temporal tables can be used to create versions of your data over time, allowing for point-in-time historical analysis of changed data.
In this presentation, we will introduce and review the essentials of system-versioned temporal tables in SQL Server. We will cover the concept of temporal storage, and demonstrate how these are implemented in SQL Server. Finally, we will demonstrate the use of temporal tables through several realistic examples.
Tim Mitchell, Principal Data Architect Tyleris Data Solutions
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.
Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.