O'Reilly logo

Pro SQL Server Internals, Second Edition by Dmitri Korotkevitch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required