How to Execute R and Python in SQL Server with Machine Learning Services
Introduction
Did you know that you can write R and Python code within your T-SQL statements? Machine Learning Services in SQLServer eliminates the need for data movement. Instead of transferring large and sensitive data over the network or losing accuracy with sample csv files, you can have your R/Python code execute within your database. Easily deploy your R/Python code with SQL stored procedures making them accessible in your ETL processes or to any application. Train and store machine learning models in your database bringing intelligence to where your data lives.
You can install and run any of the latest open source R/Python packages to build Deep Learning and AI applications on large amounts of data in SQL Server. We also offer leading edge, high-performance algorithms in Microsoft’s RevoScaleR and RevoScalePy APIs. Using these with the latest innovations in the open source world allows you to bring unparalleled selection, performance, and scale to your applications.
How-To Tutorial
In this tutorial, I will cover the basics of how to Execute R and Python in T-SQL statements. If you do not have Machine Learning Services installed in SQL Server, you will first want to follow