Prerequisites for this chapter

Tools	URL	Notes
Visual Studio 2017	To download: https://www.visualstudio.com/downloads/	The Community Edition is free.
VSTS	Sign up/sign in: https://www.visualstudio.com/team-services/	Sign up for the personal account for free.
Power Shell v2.0 or above	Download PowerShell: https://www.microsoft.com/en-us/download/details.aspx?id=42554	You will need this for setting up the Private Agent locally.

Creating the SQL Server database project

In this section, we will walk you through how to create a database project in VS2017.

1. In VS2017, click on File | New Project.
2. Choose SQL Server from Installed on the left pane and click on the SQL Server Database Project template.
3. Type Ch08 in the Name: field and SQL Server R Services Book in the Solution name: file, as shown in the following screenshot: 

Figure 8.2 New Project in Visual Studio

4. Choose the Location to save the solution.

Note

If you already have a local folder for your version control, you can specify the path here.

In this example...