Thursday, August 27th 6:30 PM

1500 NW Bethany Blvd
Suite 285
Beaverton, Oregon OR 97007
Directions to QuickStart:
Head West on Highway 26(Sunset Highway)
Exit at Cornell Road
Turn left at stoplight and cross over highway
Turn right onto Bethany Blvd at second stoplight.
The building is the first on your right.
Park in any open space
Click here for a map.

It's Time for a Change - Temporal Table Support in SQL Server 2016

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 why you may need temporal support in your tables, how to implement temporal support without a true period data type (since SQL Server doesn't yet have one), and how to query such a table using the new FOR SYSTEM_TIME clause in a SELECT statement. We will also discuss and demonstrate bi-temporal design, where both system time and application time are supported.


Vern Rabe (LinkedIn) 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 1992, 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 varied consulting contracts.



QuickStart PASS Chapter Logo Prent Ozar Pluralsight - Harcore Developer Training
TEK Systems

copyright ©2015, Portland SQL Server User Group and pdxssug.com all rights reserved.
Redistribution of any portion of this site is forbidden without prior written permission.