Get the lowest-cost and the best server colocation service in the business. Learn more.
Information Technology News.

Microsoft releases new preview of SQL Server 2016

Share on Twitter.

Get the best SMTP service for your business. Guaranteed or your money back.

Click here to order the best deal on a HP enterprise dedicated server and at a great price.

October 28, 2015

Microsoft has released a new preview of SQL Server 2016, including integration with the R language for statistical analysis.

So what's the 'R Language' you might ask? About six months ago, Microsoft completed the acquisition of Revolution Analytics, a commercial provider of software and services for the open source R language.

The new Community Tech Preview of SQL Server 2016, CTP3, integrates with the Revolution Analytics R package so you can run R analytics in the SQL Server 2016 database, rather than pulling out data for analysis on a separate server.

You can also execute R scripts via a system-stored procedure so you can query data, pass it to R, and get the results.

Another new feature in the latest preview is Transactional Replication from SQL Server to Azure SQL, where Azure SQL is Microsoft's cloud-hosted version of SQL Server.

The concept is apparently to make it easier to migrate data to the Azure service without downtime, Microsoft says.

There are also a few improvements to in-memory OLTP (online transactional processing), the technology codenamed Hekaton, and to the Stretch database technology that archives historical data to Azure SQL transparently.

New JSON support in T-SQL, the SQL Server query language, includes OPENJSON to parse JSON text and return tabular data, JSON_VALUE and JSON_QUERY for querying JSON data, and ISJSON for validating JSON-formatted text.

Other enhancements cover SQL Server Analysis Services, Reporting Services, and Master Data Services. A full list is on Microsoft's website.

Another key feature in SQL Server 2016, already previewed in the May 2016 CTP2, is called Always Encrypted.

This feature enables SQL Server 2016 to operate on encrypted data. The encryption key resides in the application, so that data is only decrypted locally.

SQL Server Reporting Services (SSRS) has been revamped so that reports are formatted in responsive HTML5, for richer reports with better browser compatibility and mobile support.

Finally, Microsoft is talking about its Azure Data Lake repository and analytics service engineered for big data processing. The technology is built on Apache Hadoop and Apache YARN, the new generation of MapReduce for filtering and sorting large datasets.

The SQL Server 2016 release date is not yet announced, but note that SQL Server 2014 was completed in March 2014, so sometime in the first quarter of 2016 would not be a surprise.

The download for SQL Server 2016 is not available at the time of this writing, but has been promised before the end of the SQL PASS Summit under way in Seattle.

Source: Microsoft.

Get the best SMTP service for your business. Guaranteed or your money back.

Share on Twitter.

IT News Archives | Site Search | Advertise on IT Direction | Contact | Home

All logos, trade marks or service marks on this site are the property of their respective owners.

Sponsored by Sure Mail™, Avantex and
by Montreal Server Colocation.

       © IT Direction. All rights reserved.