Integrating R into the SQL Server Database lifecycle workflow

Earlier in Chapter 7, Operationalizing R Prediction Models, we discussed how to create an R project in Visual Studio 2017. We also talked about integrating R code as part of sp_execute_external_script in SQL Server. Here, we will revisit Visual Studio 2017, specifically in the context of integrating R code in sp_execute_external_script as part of a SQL Server Database Project, and holistically as part of the database lifecycle workflow.

Preparing your environment for the database lifecycle workflow

In this section, we will discuss the stages of the database lifecycle workflow and the tools that we will be using. For each of the stages in the workflow, there will...