Tools
There are three main options for operationalizing R code embedded in T-SQL. All of these tools are free:
- SQL Server Management Studio (SSMS)
- R Tools for Visual Studio (RTVS)
- SQL Server Data Tools (SSDT)
This section provides an overview of how the tools can help you operationalize R code in SQL Server as part of workflows.
Using SSMS as part of operationalizing R script
SSMS is a powerful tool that allows you to operationalize your prediction analytics from the previous section. SSMS also provides the ability for you to manage various administrative tasks related to operationalizing R code in SQL Server and maintaining it, such as:
- Managing permissions, as described earlier in this chapter.
- Managing R packages (in SQL Server 2017), as described earlier in this chapter.
- Managing stored procedures that integrate R code, as described in an earlier section.
- Managing resources for SQL Server R Services, as described in Chapter 3, Managing Machine Learning Services for SQL Server 2017 and R.
- Monitoring...
