Skip to content

sql-server-python-services.md

Latest commit

 

History

History
43 lines (30 loc) · 2.68 KB

sql-server-python-services.md

File metadata and controls

43 lines (30 loc) · 2.68 KB
title Machine Learning Services with Python | Microsoft Docs
ms.date 11/03/2017
ms.reviewer
ms.suite sql
ms.prod machine-learning-services
ms.prod_service machine-learning-services
ms.component python
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 cgronlund
ms.workload On Demand

Machine Learning Services with Python

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 Python 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 and R support for distributed machine learning. You can also deploy your Python solution as a web service by using mrsdeploy.

    Do not install this feature on the same computer that is running SQL Server Machine Learning Services.

Additional resources

Set Up Python Machine Learning Services In-Database

Python Tutorials