It’s About Time: Temporal Tables 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 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.
Vern (LinkedIn | Twitter) 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.
Introducing Memory-Optimized Table Variables
Memory-Optimized Table Variables were introduced in SQL Server 2014. In this short presentation, Arnie will demonstrate the performance power of Memory-Optimized Table Variables, and he will provide compelling comparisons with both Temp tables and Table Variables.
Arnie [LinkedIn] is a Data Architect, Consultant and Trainer specializing in developer/development issues related to SQL Server. Clients include Fortune 100 enterprises, large scale NGOs, as well as domestic and foreign governments. In addition to founding and facilitating the Oregon SQL user group, he is a SQL Server MVP (for 10 years), a PASS Regional Mentor, a senior moderator for the Microsoft MSDN SQL Server Forums, member of the Microsoft TechNet Wiki Community Council, and co-founder of Portland Code Camp.
Refreshments graciously provided.
Featured Sponsor: Idera
Visit our website for more details.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.