SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.
This session takes you behind the basics of Temporal Tables and answers – after a short introduction – the following questions:
- How to handle the change of NULL constraints?
- Can Temporal Tables be renamed and what happens to the System Versioned table?
- What will happen if you change meta data (data length, data type, …)?
- What happens if you drop a column or add another column to the Temporal Table?
- What about security for the system versioned table?
- What about calculated columns in the temporal table?
You are interested in the answers to all the above questions (and more). This session will answer most of your questions about Temporal Tables.
Uwe Ricken is working with IT systems since the early ’90s. The start of experiences with Microsoft SQL Server came with the assignment for development of a membership administration software for the American Chamber of Commerce in Germany. The software has been distributed to five additional European countries.
The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a Senior DBA and Database Architect for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models, he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. The year 2013 finished with the first MVP award for his support to the Microsoft SQL Server community in Germany and Europe.
To provide his deep knowledge about Microsoft SQL Server to the interested Uwe Ricken is blogging since 2010 on http://www.sqlmaster.de about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German-speaking SQL community inside views into the technology of Microsoft SQL Server.
Uwe Ricken is a speaker on many international conferences and events and preferred topics are Database Internals, Indexing, Architecture, and Development.