SQL Server 2016 to include R

R in SQL Server

Early look at running R within SQL Server. Note that this syntax will change.

In one of the first concrete results of Microsoft's purchase of R vendor Revolution Analytics, R will be incorporated into SQL Server 2016, according to David Smith at Revolution Analytics. "SQL Server 2016 (which will be in public preview this summer) will include . . . the ability to run R within the database itself," he posted on the Revolutions blog today.

"This could make [R] adoption explode within the enterprise space," tweeted David F. Severski, a security professional in Seattle.

Why? Data scientists won't have to pull data out of SQL Server in order to run analyses in R. "Instead, you will be able to take your R code to the data, where is will be run inside a sandbox process within SQL Server itself," Smith said. That cuts down time it might take to pull massive amounts of data from a database and import it into R. Running within SQL Server also aims to solve potential problems of R being unable to handle true big-data-sized files.

One more benefit: easing tensions between database admins in IT and data scientists, since data scientists often like to pull huge amounts of data for machine-learning projects -- jobs that can take up significant amounts of computing resources, said Lindsey Allen at Microsoft. R integration will also be coming to Visual Studio, Power BI and SharePoint reporting services, she added.

Call on line 2! Six ways to add a second line to your smartphone
View Comments
Join the discussion
Be the first to comment on this article. Our Commenting Policies