How To Run R & Python in SQL Server from Jupyter Notebooks or any IDE

No more need to move data around or work on samples. You can operationalize your R and Python machine learning models directly within your enterprise grade database server. SQL Machine Learning Services enables you to work with any open source packages and additionally provides algorithms which enable multi-threaded, parallel processing for industry leading scale and performance.

Prerequisites to complete this tutorial:

Install Python Client for RevoscalePy:

Link to Jupyter Notebook from Video with all the code:

Visit our documentation to learn more:

Some of the powershell commands used in video:
Install Python Client:
.\Install-PyForMLS.ps1 -InstallFolder "C:\Program Files\MicrosoftPythonClient"

Start Jupyter Notebook:
mkdir JupyterNotebooks; cd JupyterNotebooks; ..\Scripts\jupyter-notebook