SQL Server

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: 

Advanced Analytics Using R

June 2, 2016
SQL Server 2016 includes a new R language service to help organizations perform advanced analytics on data sources using existing SQL Server skills and investments
Tags: 

Failover, Replication, and Backup Improvements

June 2, 2016
SQL Server 2016 expands replication features to reduce downtime and cost and improves off-site backup security and manageability with Azure Storage
Tags: 

JSON Features Support Mobile Applications

June 2, 2016
SQL Server 2016 supports full management of JSON data, enabling organizations to leverage existing SQL skills to access and share data with more Web and mobile applications
Tags: 

In-Memory and ColumnStore Enhancements

June 2, 2016
SQL Server 2016 includes In-Memory OLTP and ColumnStore technology enhancements that lift previous restrictions, enabling their use on a broader range of applications
Tags: 

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: 

Related Content

March 30, 2020
Azure Open Source Relational Database Services 2020 Update and Roadmap
Azure open source database services for MariaDB, MySQL, and PostgreSQL receive new releases and important back-end enhancements that improve performance, security, and manageability.
Read More
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