| title | SQL Server R Services | Microsoft Docs | |
|---|---|---|
| ms.custom |
|
|
| ms.date | 06/22/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | ba1dea65-40ea-484a-b767-53680c954934 | |
| caps.latest.revision | 38 | |
| author | jeannt | |
| ms.author | jeannt | |
| manager | jhubbard |
Python is a language that offers great flexibility and power for a variety of machine learning tasks. Open source libraries for Python include several platforms for customizable neural networks, as well as popular libraries for natural language processing. Now, this widely used language is supported in SQL Server 2017 CTP 2.0 and later.
Because Python is integrated with the [!INCLUDEssNoVersion] database engine, you can keep analytics close to the data and eliminate the costs and security risks associated with data movement. You can deploy machine learning solutions based on Python using convenient, familiar tools such as Visual Studio. Your production applications can get predictions, models, or visuals from the Python 3.5 runtime by simply calling a T-SQL stored procedure.
This release includes the Anaconda distribution of Python, as well as the new revoscalepy library, to improve the scale and performance of your machine learning solutions.
You can install everything you need to get started with Python through SQL Server 2017 setup:
-
Machine Learning Services (In-Database): Install this feature, together with the SQL Server database engine, to enable secure execution of R scripts on the [!INCLUDEssNoVersion] computer.
When you select this feature, extensions are installed in the database engine to support execution of Python scripts, and a new service is created, the [!INCLUDErsql_launchpad], to manage communications between the Python runtime and the [!INCLUDEssNoVersion] instance.
-
Machine Learning Server (Standalone): If you do not need SQL Server integration, install this feature to get Python support in Microsoft R Server. This lets you operationalize Python solutions using mrsdeploy.
Do not install this feature on the same computer that is running SQL Server Machine Learning Services.