Temporal Tables in SQL Server 2016

How Easy Dynamics Corp uses Microsoft SQL Server 2016

A Simple Question 

One of the most frequent questions that comes up in the realm of enterprise applications is: 

Who has touched / modified this data? 

Short questions usually have long answers, and this one is no exception. To understand the implications of this question, one has to understand the principle of temporal versioning. This essentially means that time is treated as a dimension over which changes to data are persisted and observed. A full discussion on this topic can be found here. This post identifies a new feature in SQL Server 2016 called temporal tables and contrasts it with the manual process of creating and managing temporal tables in previous versions of SQL Server. Continue reading “Temporal Tables in SQL Server 2016”