On-Prem: Setup SQL Server
If you instead would like to try this solution out on a virtual machine, visit the Quick Start page and use the 'Deploy to Azure' button. All the configuration described below will be done for you, as well as the initial deployment of the solution.
Prepare your SQL Server Installation
The rest of this page assumes you are configuring your on premises SQL Server 2016 or 2017 for this solution.
If you need a trial version of SQL Server see What’s New in SQL Server 2017 for download or VM options.
Complete the steps in the Set up Microsoft Machine Learning Services (In-Database) Instructions. The set up instructions file can found at https://docs.microsoft.com/en-us/sql/advanced-analytics/install/sql-r-services-windows-install
Make sure to install both SQL and Standalone version of R and Python.
Ready to Run Code
You are now ready to run the code for this solution.
-
Install the solution by following these PowerShell Instructions for deployment.
-
Typically a data scientist will create and test a predictive model from their favorite R IDE, at which point the models will be stored in SQL Server and then scored in production using Transact-SQL (T-SQL) stored procedures. You can follow along with this by following the steps in For the Data Scientist or For the Database Analyst.
