The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Jul 10 2018 02:30 UTC


What is this Temporal Table thing anyway? Come and see!

RSVP: None

What is this Temporal Table thing anyway? Come and see!

Have you ever wanted to know what the data looked like yesterday before a change was made? Have you cringed at the thought of creating triggers to get data changes logged for later analysis? 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. We will cover how to set it up, how it works, querying the tables including the history table and last but not least, how you can incorporate this feature into existing tables. Join me in a time travelling adventure to find out how you can leverage Temporal Tables in your world.


Ben has been a member of the SQL Server Community since 2000. He is currently working at MaritzCX revolutionizing the SQL Server environment and loving it. He also consults on SQL Server problems. He is a SQL Server MVP a SQL Server MCM, and has spent time in the field using SQL Server since 1997. He has worked at various companies throughout the US, as well as at Microsoft for 7 years. He is passionate about SQL Server and automation and integration and uses SMO and PowerShell regularly. He teaches DBAs how to use PowerShell as well. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook)

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids