Which version of SQL Server 2016 supports R

Posted on

Question :

Microsoft buying REvolution results (amongst other things) in the integration of R in SQL Server 2016.

Looking through the features supported by the SQL Server 2016 I cannot find R-Support. Does anyone know to what feature R-Integration belongs to or what version(s) integrate this feature?

Answer :

SQL Server 2016 Community Technology Preview 2.2 is the latest release of SQL Server 2016. This version does not have R support.

Later release of 2016 (probably 3.0) will have support for R language.

Found this slideshare presentation (slide – 130) that says R support will be in CTP 3.0.

EDIT: Announced and demoed in PASS Summit 2015 – As of SQL Server 2016 CTP 3.0, SQL server supports Advanced Analytics (RRE integration):

With this release, we are very excited to announce the public availability SQL Server R Services in SQL Server 2016, an Advanced Analytics capability which supports enterprise-scale data science, significantly reducing the friction for adopting machine learning in your business. SQL Server R Services is all about helping customers embrace the highly popular open source R language in their business. R is the most popular programming language for Advanced Analytics. You can use it to analyze data, uncover patterns and trends and build predictive models. It offers an incredibly rich set of packages and a vibrant and fast-growing developer community. At the same time, embracing R in an enterprise setting presents certain challenges, especially as the volume of data rises and with the switch from modeling to production environments. Microsoft SQL Server R Services with in-database analytics helps customers embrace this technology by supporting several scenarios.

Also, Henk blogs about Introducing Microsoft SQL Server 2016 R Services

If you’re asking about the editions of SQL Server 2016 supporting R Services (R integration), I believe that basic R integration is supported by pretty much all editions. Advanced R integration is only supported by Enterprise and Developer Editions.

Here’s more detailed information by Microsoft that might help:

In the installation center for SQL server 2016 you have two options: Standalone R server and built-in.

So far I have successfully tested built-in option on Developer edition. It allows you to run R script from SSMS after you enable it.

You should not focus on building too many tightly coupled solution, you should be focussing more on the aspects of building an ETL pipeline which uses, SQL Server as a source and later allows you to plug custom R scripts for any statistical use cases. Here you can think of using SSIS, or even KNIME for open source offerings.

Leave a Reply

Your email address will not be published. Required fields are marked *