Managing Machine Learning Services for SQL Server 2017 and R

This chapter will tackle managing R Services and the steps necessary to get R Services running from a SQL Server database. In detail, this chapter will cover the following topics:

• Installing SQL Server with R services
• Configuring the environment and installing R Tools for Visual Studio (RTVS)
• Resource Governor
• Security
• Sessions and logs
• Installing new R packages
• Managing SQL Server R services with PowerShell
• Getting to know the sp_execute_external_script external procedure

With SQL Server 2017 installation, configuration, and setting up the working environment aren't that much different, compared with how SQL Server 2016 operated when R was originally introduced. If there are differences between the versions, they will be pointed out.

Installing SQL Server with machine learning R Services using SQL Server 2016 and 2017 has minimal hardware requirements that depend on the edition of SQL Server you will be installing. SQL Server comes in several editions. More information is available on the Microsoft webpage: 

https://www.microsoft.com/en-us/sql-server/sql-server-2017-editions