Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
What's New in SQL Server 2016

What's New in SQL Server 2016

 

Published: September 2, 2015

Updated: August 31, 2015

Applies To: SQL Server 2016 Preview

>> Be sure to share your feedback on the new SQL Server 2016 capabilities on www.stackoverflow.com.

This topic summarizes information about the new features in the current monthly build of SQL Server 2016 Community Technology Preview 2 (CTP2). The topic also contains links for more detailed component level what's new information from the current and previous monthly builds.

Download

  • To download SQL Server 2016 Community Technology Preview 2 (CTP2), go to Microsoft Download Center.

  • Have an Azure account? Then go Here to spin up a Virtual Machine with SQL Server 2016 already installed.

Need help with SQL Server 2016 Community Technology Preview 2 (CTP2)? Go to StackOverFlow.

Benefits of SQL Server 2016:

  • Enhanced in-memory performance provides up to 30x faster transactions, more than 100x faster queries than disk-based relational databases and real-time operational analytics.

  • New Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without application changes.

  • Stretch Database technology keeps more of your customer’s historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure in a secure manner without application changes.

  • Built-in advanced analytics provide the scalability and performance benefits of building and running your advanced analytics algorithms directly in the core SQL Server transactional database.

  • Business insights through rich visualizations on mobile devices with native apps for Windows, iOS and Android.

  • Simplify management of relational and non-relational data by querying both with T-SQL using PolyBase.

  • Faster hybrid backups, high availability and disaster recovery scenarios to back up and restore your on-premises databases to Microsoft Azure and place your SQL Server AlwaysOn secondaries in Azure.

 

For more detailed what's new information and information on previous months, see What's New in Analysis Services.

SQL Server 2016 CTP 2.3 adds a graphical user interface to SQL Server Management Studio to configure and manage Analysis Services Extended Events. For more information, see Use SQL Server Extended Events (XEvents) to Monitor Analysis Services.

More that 50 DAX functions added! The new functions include Date and Time functions, Filter functions, Math and Trig functions, Statistical functions, and Text functions. For details, see What's New in Analysis Services.

SQL Server 2016 CTP 2.3 adds support for variables in DAX. Variables can now store the result of an expression as a named variable, which can then be passed as an argument to other measure expressions. Once resultant values have been calculated for a variable expression, those values do not change, even if the variable is referenced in another expression. For more information, see VAR Function.

For SQL Server 2016 CTP 2.3, DirectQuery now generates simpler queries that provide better performance.

 Arrow icon used with Back to Top link  SQL Server 2016 CTP 2.3 - August - A Summary of What's New

For more detailed what's new information and information on previous months, see What's New in Database Engine.

Row-level security is supported for in memory-optimized tables.

The default encryption for endpoints is changed from RC4 to AES.

 Arrow icon used with Back to Top link  SQL Server 2016 CTP 2.3 - August - A Summary of What's New

For more detailed what's new information and information on previous months, see What's New in Integration Services.

There are no changes this month for Integration Services.

 Arrow icon used with Back to Top link  SQL Server 2016 CTP 2.3 - August - A Summary of What's New

For more detailed what's new information and information on previous months, see What's New in Master Data Services.

Manage Business Rules (MDS Add-in for Excel)

In the Master Data Services Add-in for Excel you can manage Business Rules, such as creating and editing business rules. Business rules are used to validate data. For more information, see Manage Business Rules (MDS Add-in for Excel).

Many-to-Many Relationships in Derived Hierarchies

You can now create a Derived Hierarchy that displays many-to-many relationships. A many-to-many relationship between two entities may be modeled through the use of a third entity that provides a mapping between them. The mapping entity is an entity that has two or more domain-based attributes referencing other entities.

For example, entity M has a domain-based attribute that references A and a domain-based attribute that references B. You can create a hierarchy from A to B using the mapping entity.

For more information, see Show Many-to-Many Relationships in Derived Hierarchies (Master Data Services)

Merge Conflicts

If you try to publish data that has been changed by another user, the publish will fail with a conflict error. To resolve this error, you can perform merge conflicts and republish the changes. For more information, see Merge Conflicts (Master Data Services) and Merge Conflicts (MDS Add-in for Excel).

 Arrow icon used with Back to Top link  SQL Server 2016 CTP 2.3 - August - A Summary of What's New

For more detailed what's new information and information on previous months, see What's New in Reporting Services.

A new HTML5 rendering engine that targets modern web "full" standards mode and modern browsers. The new rendering engine no longer relies on quirks mode used by a few older browsers. The new rendering engine is used by default but you have the option of switching back to the previous rendering engine and providing feedback to Microsoft on the new HTML5 approach.

The ribbon allows you to toggle between:

  • Comparability mode and running the old rendering engine.

  • Preview of the new HTML 5 rendering mode

 

The core Report Builder user interface is now a modern look and feel with streamlined UI elements.

ssrs_rbfacelift_new

. Enhance your reports with Tree Map ssrs_treemap_icon and Sunburst ssrs_sunburst_icon charts, great ways to display hierarchal data.

For more information, see Tree Map and Sunburst charts in Reporting Services.

For more information about SQL Server 2016 Community Technology Preview 2 (CTP2), or to download the SQL Server 2016 Community Technology Preview 2 (CTP2) data sheet, see SQL Server 2016 Preview.

Microsoft SQL Server 2016 data sheet

 Arrow icon used with Back to Top link  SQL Server 2016 CTP 2.3 - August - A Summary of What's New

>> Be sure to share your feedback on the new SQL Server 2016 capabilities on www.stackoverflow.com.

Community Additions

ADD
Show:
© 2015 Microsoft