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.
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