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

Did you know that you can execute R and Python code in SQL Server? Machine Learning Services in SQL Server, brings AI directly to your data:

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:
How to Install SQL Server Machine Learning Services:
How to Enable SQL Server Machine Learning Services:
Basics of R and Python Execution in SQL:

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 FilesMicrosoftPythonClient”

Start Jupyter Notebook:
mkdir JupyterNotebooks; cd JupyterNotebooks; ..Scriptsjupyter-notebook

Duration: 3:43
Publisher: Microsoft Cloud Platform
You can watch this video also at the source.

Inxy Hosting CDN Marketplace