This chapter provides an overview of several new SQL Server 2016 features, such as temporal tables, stretch databases, row-level security, dynamic data masking, and Always Encrypted.
The majority of systems nowadays deal with data that changes over time. New data is collected and inserted into the system, old data is purged, and catalog entities are modified.
There are two requirements that often exist in systems. The first is keeping an audit trail of any data changes, providing information on who changed what and when it happened. There are many ways to build ...