"...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
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.