The new SQL Server 2016 is now available as part of the Community Technical Preview program, and as presaged it embeds connectivity with the R language and the big-data statistical algorithms of Revolution R Enterprise.
SQL Server R Services 2016 includes two ways of calling R. The first is by embedding R code direcly in a SQL Stored Procedure, which can then be called by other applications to embed charts or tables created by R using data in the database.
The second way allows you to use the RevoScaleR package in Revolution R Enterprise (now called SQL Server R Services and included with SQL Server 2016) to create statistical models using data in SQL Server 2016, and use the computing power of the database to fit the model. The process in R is follows:
- Make a connection to the SQL Server 2016 database (using login credentials)
- Create an object referencing a table or query in SQL Server 2016
- Instruct Revolution R Enterprise to perform computations in the database (by setting the "compute context" to SQL Server 2016)
- Use one of the RevoScaleR "rx" functions to fit the model, using a syntax similar to standard R functions.
Heres some code demonstrating fitting a linear regression on the famous "airlines" data set, as stored in the database (and for more background, see this blog post by Andrie de Vries):
For more on the new features in SQL Server 2016 and how to access the Community Technology Preview, follow the link below.
SQL Server blog: SQL Server 2016 Community Technology Preview 3.0 is available
Do we get R tooling in SSDT?
Posted by: Momchil Nikolov | October 29, 2015 at 00:54
Got more info ? No sign of CTP3.0 on MSDN Subscriber Download page. Latest is still CTP2.4.
Posted by: marisk | October 30, 2015 at 08:59
@marisk, you should be able to get it now from the TechNet Evaluation Center.
Posted by: David Smith | October 30, 2015 at 14:07