How to Use Temporal Tables in SQL Server 2016

Have you ever needed to look at what data in a table used to look like?

If you have, it probably took a knuckle-cracking filled session of writing group-by statements, nested sub-queries, and window functions to write your time-travelling query.

Fortunately for us, SQL Server 2016 introduces a new feature to make our point-in-time analysis queries easy to write: temporal tables.

Full blog post: https://bertwagner.com/2017/07/19/how...

Want to receive the latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/

Elsewhere on the internet:
https://bertwagner.com
Twitter: bertwagner

• #science_technology
• #sql_server
• #temporal_tables
• #historical_data
• #sql_server_2016