Microsoft Announces General Availability Of SQL Server 2016

sql-server-2016Microsoft announces the general availability of SQL Server 2016, the world’s fastest and most price-performant database for HTAP (Hybrid Transactional and Analytical Processing) with updatable, in-memory columnstores and advanced analytics through deep integration with R Services. Software applications can now easily deploy sophisticated analytics and machine learning models in the database resulting in 100x or more speedup in time to insight, compared to deployments of such models outside of the database.

A new platform for intelligent applications

The majority of advanced analytic applications use a primitive approach of moving data from databases into the application tier to derive intelligence. This approach has been because of the high latency due to the data movement,and does not scale as data volumes grow,  and thus burden the application tier with the task of managing as well as maintaining the analytical models. The deep analytics on real-time transactions are quite impossible without a lot of heaving lifting.

The SQL Server 2016 simplifies analytics in the way databases simplified enterprise data management, by moving the analytics quite close to where the data is managed instead of the other way around. It has gone on to introduce a new paradigm where all joins and aggregations as well as machine learning are securely performed within the database itself without moving the data out, hence enabling analytics on real-time transactions with great speed and parallelism. Hence, analytical applications are much simpler and require only querying the database for analytic results. Now you can easily update the machine learning models, deploy new models, as well as monitor their performance, which can easily be conducted in the database without recompiling and redeploying. In addition, the database can serve as a central server for the enterprise’s analytical models as well as multiple intelligence applications which can leverage the same models. It is reflectively simple how mission-critical intelligent applications can now be built as well as managed in the enterprise.

Microsoft states,

SQL Server 2016 comes with several features and tools to support cross-platform analytics. Polybase allows you to run queries on external data in Hadoop or Azure blob storage. It can push computation to Hadoop where appropriate, so that your analytical application can join and integrate data from big data stores with the data in the relational store. Microsoft R Services, which is integrated with SQL Server also runs on multiple Hadoop distributions and is also integrated with Azure HDInsight + Spark, enabling both choice and standardization in developing analytics code. And finally, R Tools for Visual Studio allows the ease of use of the modern Visual Studio IDE for developing analytical code in R.

Unified Experience

The package will let users “scale performance with cost efficiency,” suggested Anne Moxie, a senior analyst at Nucleus Research. “They won’t have to invest as heavily in infrastructure to achieve computing capabilities that will be able to accommodate peaks in use.”

Microsoft “has been working on unifying its organization across the board,” she told TechNewsWorld.

Customers “will experience higher ROI from the combination of relational and nonrelational data, [which] makes up the large majority of data available,” Moxie said. Using the two together for complete analysis is critical.

Strong Hybrid Solution

SQL Server 2016 will let users host Microsoft’s Azure cloud locally “so it will also run on premises on a local Azure instance,” pointed out Rob Enderle, principal analyst at the Enderle Group.

“This may be one of the strongest hybrid solutions we’ve seen so far, given the near-identical platforms of public and private Azure,” he told TechNewsWorld.

Azure “represents a more agile platform than we’ve seen before,” Enderle continued. “In a way, it obsolesces the traditional cloud because it potentially extends from on-premises to hosted with virtually no change, so the concept of on-premises versus cloud is obsolete.”

Duking It Out With Oracle, Newbies

With SQL Server 2016, Microsoft isn’t just targeting its own customer base — it’s also challenging Oracle. In March, it offered free licenses to Oracle customers to make the switch.

However, switchers would have to subscribe to Microsoft’s Software Assurance program.

The offer is good until June 30 and includes support services to kick-start migration, access to SQL Server Essentials, and free DBA training.

“Given the importance of the sales generated by Microsoft’s server group to the company as a whole,” getting existing clients to upgrade is a critical issue, pointed out Charles King, principal analyst at Pund-IT.

“Microsoft also wants to aggressively grow that business, and Oracle customers constitute the largest pool of potential new clients,” he told TechNewsWorld “Controversies about Oracle’s pricing model and policies could result in a great deal of interest in Microsoft’s offer.”

Further, there’s “growing interest in alternative open source database solutions running on industry-standard x86 hardware,” and Microsoft likely will position SQL Server 2016 “to strengthen its hand against those upstart offerings,” King surmised.

Pricing and Other Issues

Microsoft announced that it will charge for SQL Server 2016 on a per-core basis rather than per processor, and that has raised some hackles.

However, “this is similar to Oracle’s pricing and represents an industry trend. The old pricing forced decisions that favored high core counts in single processors, which often hurt performance and increased thermal management issues,” Enderle said.

“The Linux support and hybrid advantages should let [SQL Server 2016] stand out, and the pricing changes should focus buyers back on performance, where it should be, and off gaming prices with processor architectures,” he suggested.

Linux support for SQL Server 2016 will be available mid-2017.

Microsoft will offer three versions of SQL Server 2016: Enterprise, Standard and Express. The company in March offered a Developer edition as a free download.

Earlier Microsoft has announced that SQL Server 2016 Developer version is available to download for FREE. You will have to sign in to Visual Studio Dev Essentials before you can download SQL Server 2016 Developer Edition. Remember that Visual Studio Dev Essential is FREE developer program.

Click to Download SQL Server 2016 Developer Edition for FREE

If you have an MSDN subscription you can download SQL Server 2016 from here.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s