Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

SQL Server 2016 preview shows off new features, improvements

Experts discuss the public preview of SQL Server 2016 and the best new features as early adopters ready themselves to put SQL Server 2016 into production.

One of senior DBA Basit Farooq's clients is making a jump forward with its new financial application platform. While its existing servers will continue to run SQL Server 2012 and 2014, the servers for the new platform are going directly to SQL Server 2016 when it officially releases in October.

Farooq is currently in the initial testing phases for SQL Server 2016. Farooq first heard about the release of SQL Server 2016 while attending Microsoft Ignite. He downloaded the CTP 2 preview as soon as it was available and has had a little over a week to explore the new features.

According to Farooq, one of the favorite new features for his developers is the integration of PolyBase, which allows SQL Server 2016 to connect to Hadoop via T-SQL programs. "Previously [Microsoft] never offered analytical tools. This version has an analytical tool in the form of PolyBase's connection to SQL Server," he said. By incorporating PolyBase into SQL Server 2016, organizations like Farooq's client's no longer have to purchase it separately. Also, connecting SQL Server and Hadoop means that "data is actually stored on the server," whereas previously you had to use storage.

Another favorite feature is the JSON incorporation of the R language. The incorporation of R is important for data scientists because they won't have to take code out of the database in order to run the R programming language. R allows the user to run queries on server data.

Farooq said that for his work as a DBA, the most important new features are upgrades to performance and security. "We need clients' confidential data to be more secure," Farooq said, "so we need security features like Always Encrypted." Currently, Farooq runs third-party security software DbDefence against his data to encrypt it. He is looking forward to using Always Encrypted, which keeps data encrypted even during transactions and queries. Farooq knows of no other relational database management system that provides a feature like Always Encrypted.

Other features that Farooq likes include the enhancements to in-memory that increase data by a hundredfold and the support for indexes in in-memory. He added, "The query data store and live query statistics will make all DBAs lives easier." The query data store and live query statistics allow DBAs to see which queries are taking up the most resources and plan accordingly.

SQL Server 2016 incorporates customer wishes

Farooq's client isn't alone in its rapid adoption of SQL Server 2016. With the recent release of the public preview, other SQL Server users are taking notice.

Denny Cherry, owner and principal consultant of Denny Cherry and Associates Consulting, has two clients trying out SQL Server 2016. Cherry is tied in with the development team for SQL Server 2016 and, through the Microsoft Early Access Program, and has been able to work with SQL Server 2016 for the past three months. Because of the extra lead time, Cherry has a client who is in the process of putting SQL Server 2016 into production right now.

Next Steps

Find out more about the new features announced for SQL Server 2016

Learn about another way to combine SQL Server and Hadoop with the Analytics Platform System

This was last published in June 2015

Essential Guide

SQL Server 2016 release guide: News and analysis on the new version

Join the conversation

4 comments

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

Are you planning on upgrading to SQL Server 2016?
Cancel

Microsoft is releasing SQL Server versions so fast that customers are unable to make up their mind which version they should go to after SQL Server 2008 R2 release.



I am still looking for a reports like Oracle AWR to have a snapshot of my performacne of database in a simple html report.


When are you going for such feature?


Also please suggest the lifecycle for support for 2012,2014 and upcoming 2016 so that it would be easy for planning which version we should target.


 

Cancel
Confusion caused by speed that Microsoft is releasing its new versions is a common problem people seem to have. Unfortunately, SQL Server doesn't have some thing Oracle AWR to help you out. There are some workarounds, but nothing as simple.

I found a workaround for SQL Server 2008 from someone at Microsoft over on social.msdn.microsoft.com. Here is the link: 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/39022a73-c415-4bdc-a2ba-27a470a41728/awr-equivalent-in-sql-server-2008

I haven't seen anything like that for later versions, but you may have better luck than me.

As for lifecycle planning, Microsoft has its end of support dates planned all the way into the 2020s for mainstream support as well as extended support and service pack support.

SQL Server 2008:
https://support.microsoft.com/en-us/lifecycle/search?sort=PN&alpha=sql%20server%202008&Filter=FilterNO

SQL Server 2012:
https://support.microsoft.com/en-us/lifecycle/search/default.aspx?alpha=sql%20server%202012&Filter=FilterNO

SQL Server 2014:
https://support.microsoft.com/en-us/lifecycle/search?sort=PN&alpha=sql%20server%202014&Filter=FilterNO

Unfortunately, Microsoft doesn't have anything listed yet for SQL Server 2016's lifecycle.

I hope that helps.
Cancel
You say SQL Server 2016 releases in October - should that mean June?
Cancel

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close