One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates. Note that this feature is also available in Azure SQL Databases.
My introduction video on temporal tables is available on Channel9 (Microsoft). The video gives you a short introduction to temporal tables and how to use them for Change Data Capture (CDC):
My demo T-SQL scripts are available here:
I can recommend the following resources for getting started with temporal tables:
- My introduction article on SQL Server Central
- MSDN documentation on SQL Server temporal tables
- Getting started with temporal tables in Azure SQL Databases