First Preview Of SQL Server 2016
Written by Kay Ewbank   
Thursday, 11 June 2015

Microsoft has released a public beta of SQL Server 2016 with better data analysis and improved performance.

Other interesting additions to the new version include the ability to have your data encrypted both at rest and when being transferred; and the ability to ‘stretch’ your warm and cold transactional data from a local server to Microsoft Azure.

 

sql2016

 

Some of the improvements in the new version (row level security and dynamic data masking) have been introduced in Azure, and are only now being added to SQL Server, showing perhaps that Microsoft sees the need to make Azure better is more important than improving SQL Server.

The ability to encrypt data no matter where it is currently located means, SQL Server can perform operations without you having to decrypt data; all encryption happens transparently inside the application. The ‘Stretch Database’ feature means you can move (or dynamically stretch) warm and cold transactional data to Microsoft Azure, including encrypted data.

According to a blog post from T.K. Ranga Rengarajan, the Microsoft VP who leads engineering for Microsoft’s Database and Big Data businesses, the analysis improvements mean that in-memory OLTP can be used with “a significantly greater number of applications”.

He says that the enhancements:

"introduce the unique capability to use our in-memory columnstore delivering 100X faster queries on top of in-memory OLTP to provide real-time operational analytics while accelerating transaction performance”.

Other improvements include the ability to have up to three synchronous replicas, DTC support and round-robin load balancing of the secondaries. Row level security is finally being added, so you can control access to data based on the characteristics of the user. Native JSON support has also been added, so you can parse and store JSON data, and export relational data to JSON.

There’s an interesting sounding addition in the form of Query Data Store, which stores a log giving full history of query execution so DBAs can pinpoint expensive/regressed queries and tune query performance.

 sql2016icon

More Information

Download SQL Server 2016 Preview

SQL Server 2016 first public preview now available!

Related Articles

SQL Server 2014 Released

 

To be informed about new articles on I Programmer, install the I Programmer Toolbar, subscribe to the RSS feed, follow us on, Twitter, FacebookGoogle+ or Linkedin,  or sign up for our weekly newsletter.

 

Banner


Hour Of Code 2024 Is About To Kick Off
04/12/2024

This year the event that aims to provide a coding experience for all school students and anyone else who wants to join in runs between December 9th and 15th and includes new activities. Let's find out [ ... ]



Fermyon's Spin WebAssembly Version 3.0 Released
26/11/2024

The open source developer tool for building, distributing, and running serverless WebAssembly applications reaches version 3.0. What's new?


More News

 

espbook

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Thursday, 11 June 2015 )