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-to-use-sql-temporal-tables-for-easy-point-in-time-analysis/

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
https://twitter.com/bertwagner

Видео How to Use Temporal Tables in SQL Server 2016 канала Bert Wagner