SQL Server 2016 - Getting started with R Services

R Services (In-Database) provides a platform for developing and deploying intelligent applications that uncover new insights.

R Services (In-Database) integrates the R language with SQL Server, you can keep analytics close to the data and eliminate the costs and security risks associated with data movement.

To install R Services

Click on SQL Server set up file and follow below steps:

To use R code in T-SQL:

Execute below commands from SSMS and then restart both SQL Server Launchpad & SQL Server services

Exec sp_configure  'external scripts enabled', 1  
Reconfigure  with override   


After successfully setting up R-Services, let us try tutorial from MSDN BOL

Open Windows PowerShell command console and run below commands to download data & scripts:

Set-ExecutionPolicy Unrestricted -Scope Process -Force  

Change the destination directory if required:

$source = 'https://raw.githubusercontent.com/Azure/Azure-MachineLearning-DataScience/master/Misc/RSQL/Download_Scripts_R_Walkthrough.ps1'  
$ps1_dest = "$pwd\Download_Scripts_R_Walkthrough.ps1"  
$wc = New-Object System.Net.WebClient  
$wc.DownloadFile($source, $ps1_dest)  
.\Download_Scripts_R_Walkthrough.ps1 –DestDir 'C:\tempR'

Run below command from Windows PowerShell command console to execute downloaded scripts [create database, tables, stored procedure, function and import data]


Open RGui and Install R libraries by running below commands

# Install required R libraries for this walkthrough if they are not installed.   

if (!('ggmap' %in% rownames(installed.packages()))){  
if (!('mapproj' %in% rownames(installed.packages()))){  
if (!('ROCR' %in% rownames(installed.packages()))){  
if (!('RODBC' %in% rownames(installed.packages()))){  

install.packages("ggmap", lib=grep("Program Files", .libPaths(), value=TRUE)[1])  
install.packages("mapproj", lib=grep("Program Files", .libPaths(), value=TRUE)[1]) 
install.packages("ROCR", lib=grep("Program Files", .libPaths(), value=TRUE)[1]) 
install.packages("RODBC", lib=grep("Program Files", .libPaths(), value=TRUE)[1])

Other lessons that are part of this tutorial can be continued from here.


No comments: