Everything You Wanted to Know About Implementing Temporal Tables - Ben Miller

Have you ever wanted to know what the data looked like yesterday before or after a change was made? Have you cringed at the thought of creating triggers to capture data changes for analysis in the future? Looking at a new feature in SQL 2016 called Temporal Tables gives you the ability to create a table that automatically keeps track of your data in time. Magic was never meant to be part of IT, but SQL Server has done a great job with this new feature. You will learn how to set it up on a new table or an existing table, how it works in practice, and querying the tables including the history table using new syntax. Coverage of version 2016 through what is coming in SQL 2019, including Retention Policies. Join me in a time travelling adventure to find out how you can leverage Temporal Tables in your world.
Watch the session recording from PASS Summit 2019. For updates on the future of PASS, SQLSaturdays and PASS Summit opt in here: www.red-gate.co...