Home » Research » 2016 06

Research Table of Contents

SQL Server 2016 Evaluation Guide
Report by: Andrew Snodgrass
Posted: June 2016
SQL Server 2016 includes the most extensive range of performance, security, business intelligence, auditing, and management improvements in several versions
SQL Server 2016 includes platform and functionality improvements that boost performance, address security for data in motion, and deliver new on-premises BI capabilities
SQL Server 2016 includes In-Memory OLTP and ColumnStore technology enhancements that lift previous restrictions, enabling their use on a broader range of applications
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
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
SQL Server 2016 introduces a data management technology called Stretch Database that enables on-premises databases to store historic data on Azure with minimal application changes
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
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
SQL Server 2016 expands replication features to reduce downtime and cost and improves off-site backup security and manageability with Azure Storage
SQL Server 2016 Reporting Services includes new user clients, design tools, and mobile reporting options; however, most features require Enterprise edition
SQL Server 2016 Analysis Services and Integration Services receive features that improve performance and simplify user access, although most features require Enterprise edition
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
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
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
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
SQL Server 2016 arrived in June 2016 and brought limited licensing changes, but it could still significantly impact some customers
Resources for articles included in this report