April 27, 2017 6:30 PM
Slalom Consulting (Fox Tower - 25th Floor)
805 SW Broadway
It’s Time for a Change: Temporal Table Support in SQL Server 2016 with Vern Rabe
Without temporal tables (AKA history tables), we can only see the current version of data. We can’t see rows that have been deleted or rows as they existed before the latest update. The temporal table support in SQL Server 2016 gives us the ability to create system maintained “history” tables to track all changes to the table data. In this session we’ll discuss how you can benefit from temporal support in your tables, how to implement temporal tables in SQL Server 2016, and how to write “time travel queries” using the new FOR SYSTEM_TIME clause in a SELECT statement to easily query historical information. This is the presentation that Vern gave at PASS. About a year or so ago, Vern gave a presentation to our group on the temporal table based upon I think an early RTC of SQL 2016. This is the update of that original presentation. Don’t miss this one.
Vern is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases since 1993, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and consulting contracts.