© Dmitri Korotkevitch 2016

Dmitri Korotkevitch, Pro SQL Server Internals, 10.1007/978-1-4842-1964-5_5

5. SQL Server 2016 Features

Dmitri Korotkevitch

(1)Tampa, Florida, USA

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.

Temporal Tables

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

Get Pro SQL Server Internals, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.