Temporal tables, introduced with SQL Server 2016, have a number of useful applications within the data warehouse. This session provides an introduction to temporal tables and what you need to know about them in order to get started using them in your data warehouse.
Learn how create temporal tables from scratch or convert existing tables, find out what the catches are and when you should (and probably shouldn't) consider using them, how they can simplify the code needed in comparison to other solutions and take a brief look at performance in comparison to their alternatives. Finally, we walk through some real-world use cases.
Barney Lawrence has over a decade's experience on the Microsoft data platform having moved from the guy who knows Excel, to Data Analyst, to Accidental BI Developer and finally to Actual BI Developer. He currently works as a Senior BI Developer for Jet2.com