How to Enable Machine Learning Services in SQL Server – #Microsoft

Machine Learning Services in SQL Server, brings AI directly to your data: https://aka.ms/SQLMLOverview.

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: https://aka.ms/DownloadSSMS

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

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

To learn how to install Machine Learning Services, check out this related video:
How to Install Machine Learning Services: https://aka.ms/InstallMLServices

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: https://aka.ms/ExecuteMLServices

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: https://aka.ms/InstallSQLMLDocs
Advanced Execution Documentation: https://aka.ms/ExecuteSQLMLDocs

About The Author
- Founded in 1975, Microsoft (Nasdaq “MSFT”) is the worldwide leader in software, services, devices and solutions that help people and businesses realize their full potential.

Tell us what you think...