1 / 6

SQL Server 2017 has extended support for Python

SQL Server was originally developed as an enterprise database system for Windows platform. In 2016, Microsoft made the relational database management system (RDBMS) cross-platform. It enabled users to run SQL Server on three distinct platforms — Windows, MacOS (via Docker) and Linux. Also, it released a set specialized tools and services to help users to migrate SQL Server on Linux.

mindfiresolutions
Download Presentation

SQL Server 2017 has extended support for Python

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server 2017 has extended support for Python

  2.  SQL Server was originally developed as an enterprise database system for Windows platform. In 2016, Microsoft made the relational database management system (RDBMS) cross-platform. It enabled users to run SQL Server on three distinct platforms — Windows, MacOS (via Docker) and Linux.  Also, it released a set specialized tools and services to help users to migrate SQL Server on Linux. Recently, Microsoft announced the first release candidate (RC) of SQL Server 2017 for both Windows and Linux platforms.

  3.  The Windows version of SQL Server 2017 now supports a widely used programming language like Python. As a general purpose programming language, Python is used widely for developing big data applications and performing data analysis.  While using the RDBMS, the developers can now use Python for machine learning and in-database analytics. Also, they can access an array of third- party libraries for Python seamlessly. Hence, the integration will make it easier for programmers to create a variety of big data applications.

  4. Python Script Execution Microsoft allows developers to integrate Python with various editions of SQL Server 2017. The integration enables programmers to execute Python scripts seamlessly. They can write custom big data applications in Python, while using SQL Server 2017 as the primary data source. The programmers even have option to embed Python code directly into SQL Server as T-SQL stored procedure.

  5. Python Distribution At present, SQL Server 2017 supports a single Python distribution —  CPython. The programmers can take advantage of CPython to boost performance of applications by generating C code from Python modules. However, they are not required to install Python or CPython additionally. SQL Server automatically installs CPython 3.5 as part of the setup process. However, the developers still have option to install custom Python packages.

  6. No Data Movement While using SQL Server 2017, programmers are not required to move data from the database to the Python application or model. The integration enables them to run Python scripts directly in the RDBMS. In addition to running Python code securely inside the database, the developers can also avoid a number of issues related to integrity, compliance and governance. Hence, the integration will simplify and accelerate custom big data application development. Content Designed By: Mindfire Solutions

More Related