How to Enable Machine Learning Services 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.

SQL Server Management Studio Download Link:

Code used in video for quick copy/paste:
Enable Machine Learning Services:
EXEC sp_configure ‘external scripts enabled’, 1

Hello World:
EXEC sp_execute_external_script @language =N’Python’,
print(“Hello World”)

To learn how to install Machine Learning Services, check out this related video:
How to Install Machine Learning Services:

To learn the basics of how to execute R/Python code. Check out this related video:
How to Execute R/Python code in SQL Server:

Visit our documentation to learn more advanced techniques like how to execute R/Python in SQL Server from your own remote IDE like Jupyter Notebooks, PyCharm, RStudio, etc.

Install Documentation:
Advanced Execution Documentation:

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