INTRODUCTION

There are many reasons to upgrade to SQL Server 2016, not the least of which are several new features, but there are also numerous enhanced features DBAs are looking forward to working with.

Microsoft touts SQL Server 2016 for its ability to deliver mission-critical performance and help users obtain deeper insights across data, as well as for its hyperscale cloud capabilities. It also has in-memory enhancements and advanced analytics capabilities.

Table of Contents

Stretch Databases

Offers enhanced backups and migration to the cloud, enhanced availability with cloud replicas, and enhanced consistency in working with SQL Server on premises, SQL Server on Azure Virtual Machines, and Azure SQL Database.

Row-Level Security

Row-level security provides fine-grain access control to isolate specific row(s) in a table in the database. While selecting the data from the table, rows are filtered based on the execution context of every query.

Temporal Tables

Temporal tables make it possible for the database administrator to create a snapshot of the data at any point in time in the past.

Native JSON Support

Walk through of common methods of creating JSON documents inside SQL Server natively.

Load Balancing with
Availability Groups

Offers more replicas, load balancing, and greater automation.

Dynamic Data Masking

Dynamic Data Masking is a security feature designed to prevent sensitive data or personal information from being seen by non-privileged users.

Troubleshooting with
Live Query Statistics

With Live Query Statistics, one does not have to wait to get the query plan. There are multiple ways to enable the feature.

Third-Party Tools
for SQL Server 2016

Third-party tools are designed to help database administrators attend to tasks such as system administration, backup, monitoring, regulatory compliance, and reporting. Some of these are designed to provide users with a quick visual representation of what’s happening with their systems.

Making the Move to SQL Server 2016

Here’s your chance to learn why this version has been called the best of the SQL Server family. Download Making the Move to SQL Server 2016, a new white paper from Datavail.


Download Now