Setting up and configuring ML services

SQL Server's ML Services is based on a feature called satellite queries. The purpose of ML Services is to allow us to use languages other than the common T-SQL language so that we can have access to further data-processing options, primarily in data science tasks. From an architectural perspective, ML Services contain R and Python runtimes, which are reachable via a helper service called SQL Server Launchpad. This service is installed alongside the SQL Server when the Machine Learning feature is selected during the setup process.

First of all, we have to check which runtimes are installed. We also should check whether the SQL Server Launchpad service is running. The installation folders of both R Services ...

Get Hands-On Data Science with SQL Server 2017 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.