Temporal Data in SQL Server 2016

Temporal in SQL Server 2016 | Data Exposed | Channel 9
"...Borko Novakovic, a Program Manager in the SQL Server team, is in Redmond all the way from his home in Belgrade, Serbia to introduce us to the new Temporal technology being introduced in SQL Server 2016. Temporal in SQL Server is designed to simply the handling of time-varying data. It provides the ability to look at data trends, types of data changes, and the overall data evolution within your database.
... Temporal ... will be included in Azure SQL Database and SQL Server 2016."

SQL Server Temporal Tables @MSDN

"SQL Server 2016 Community Technology Preview 2 (CTP2) introduces support for temporal tables as a database feature that provides built-in support for provide information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. 

Temporal is a database feature that was introduced in ANSI SQL 2011 and is now supported in SQL Server 2016 Community Technology Preview 2 (CTP2). Temporal is a database feature that was introduced in ANSI SQL 2011 and is now supported in SQL Server 2016 Community Technology Preview 2 (CTP2)"

---

The way this works is that when data are updated in the main db table that is flagged as "temporal", 

previous value is moved into a separate (hidden) table along with the timestamp. This way previous values are available for query based on time of update.