SQL Server

Tuning and Management Enhancements

June 2, 2016
SQL Server 2016 introduces new query tuning features to resolve performance issues and enhanced management tools that provide a single portal to manage hybrid deployments
Tags: 

Reporting Services

June 2, 2016
SQL Server 2016 Reporting Services includes new user clients, design tools, and mobile reporting options; however, most features require Enterprise edition
Tags: 

Security Enhancements

June 2, 2016
SQL Server 2016 introduces new security features that will help organizations meet regulatory security requirements, including securing data in motion and granular row-level controls
Tags: 

SQL Server On-Premises Compared to Azure Offerings

June 2, 2016
SQL Server database deployment scenarios (on-premises and Azure-based) offer traditional SQL Server functionality but vary in terms of cost, management features, and capacity
Tags: 

Introduction

June 2, 2016
SQL Server 2016 includes platform and functionality improvements that boost performance, address security for data in motion, and deliver new on-premises BI capabilities
Tags: 

Selecting an Edition of SQL Server 2016

June 2, 2016
Selecting the optimal edition of SQL Server 2016 involves understanding the features and limitations of each edition and the role comprised by each business scenario
Tags: 

Analysis and Data Integration Improvements

June 2, 2016
SQL Server 2016 Analysis Services and Integration Services receive features that improve performance and simplify user access, although most features require Enterprise edition
Tags: 

Temporal Tables Automate Tracking Changes

June 2, 2016
SQL Server 2016 introduces a new type of table, temporal table, that simplifies tracking data changes with stronger system controls and will benefit auditing and development efforts
Tags: 

PolyBase Accesses Big Data

June 2, 2016
SQL Server 2016 PolyBase features simplify the ability to query unstructured data in Hadoop and Azure Blob Storage, but performance demands may require multiple servers and additional licensing
Tags: 

Executive Summary

June 2, 2016
SQL Server 2016 includes the most extensive range of performance, security, business intelligence, auditing, and management improvements in several versions
Tags: 

Related Content

December 27, 2019
On-Premises Software Roadmap Report (Feb. 2020)
Provides support retirement dates and service pack histories for past product versions. This Roadmap helps customers plan for product retirements, schedule migrations, plan evaluations, and budget for purchases.
Read More
December 27, 2019
On-Premises Software Roadmap Poster (Feb. 2020)
Provides support retirement dates and service pack histories for past product versions. This Roadmap poster helps customers plan for product retirements, schedule migrations, plan evaluations, and budget for purchases.
Read More
December 22, 2019
Azure SQL Database Previews Hardware Choice for High-End Workloads
SQL Database is previewing hardware-specific selections for high-end compute- and memory-intensive databases; selections are based on Azure VM families.
Read More