This post shows you how to start with Machine Learning Service in SQL Server 2017. One of the feature added to SQL Server 2017 is machine learning. There are two language of choices R and Python. I am a R user than Python user. So this post is more R oriented. Many people don’t know where to start, like me, few weeks back. First you must install SQL Server with Machine Learning Services here:
Once you have done the installation make sure the Windows Service MSSQLLaunchpad is running. Start SQL Server Management Studio. Type this in the query pane.
‘external scripts enable’, 1 RECONFIGURE
Test the R language is working in SQL Server 2017.
sp_execute_external_script @language =
N’R’, @script =
N’ a <- 1 b <- 2 c <- a/b d <- a*b print(c, d)’