"SQL Server 2017": Now with Python support
Last week, Microsoft presented SQL Server 2017 at the Data Amp internet conference. New features of the solution were announced during the presentation. One of the most significant innovations was the integration of the Python language.
/ Flickr / Jonathan Kriz / CC
One of the main functions of SQL Server 2016 was the integration of the R language - an open language for statistical analysis. Users could, using the stored procedure sp_execute_external_script, run code R, which takes advantage of parallel computing. The first parameter of this procedure was @language. Microsoft specifically made the procedure "open", and now added support for another language - Python.
')
Users were able to run Python scripts, as well as embed Python code directly into SQL Server databases, including it as a T-SQL stored procedure. This allows Python code to be deployed in a work environment with data that it will process.
You do not need to pre-install Python. During setup, SQL Server 2017 will download and install the CPython 3.5 interpreter version. However, users will still be able to install other implementations of the programming language. The installation also includes the Anaconda distribution, widely used in Data Science, and RevoScalePy, a feature set for data analysis.
Database administrators will be able to set limits on the behavior of Python and block scripts that threaten security — isolating processes, controlling system privileges and network access. As for scientists, the innovation will allow them to build models using full data sets on SQL Server, abandoning the reduced samples. They are also able to use any Python machine learning packages. Application developers can simply call stored procedures with a script and even use Python and R models in the same application at the same time.
Among other innovations in SQL Server 2017, you can select the graph database in the database engine - it is useful in areas such as predictive analytics and the Internet of Things (IoT) - as well as adaptive query plans.
PS 1cloud company offers to rent additional software licenses to the server: SQL Server Web Edition, SQL Server Standard Edition, SQL Server Enterprise Edition, Microsoft Office, etc. Details here .
PPS What else do we write in our blog:
/ Flickr / Jonathan Kriz / CC
One of the main functions of SQL Server 2016 was the integration of the R language - an open language for statistical analysis. Users could, using the stored procedure sp_execute_external_script, run code R, which takes advantage of parallel computing. The first parameter of this procedure was @language. Microsoft specifically made the procedure "open", and now added support for another language - Python.
')
Users were able to run Python scripts, as well as embed Python code directly into SQL Server databases, including it as a T-SQL stored procedure. This allows Python code to be deployed in a work environment with data that it will process.
You do not need to pre-install Python. During setup, SQL Server 2017 will download and install the CPython 3.5 interpreter version. However, users will still be able to install other implementations of the programming language. The installation also includes the Anaconda distribution, widely used in Data Science, and RevoScalePy, a feature set for data analysis.
Database administrators will be able to set limits on the behavior of Python and block scripts that threaten security — isolating processes, controlling system privileges and network access. As for scientists, the innovation will allow them to build models using full data sets on SQL Server, abandoning the reduced samples. They are also able to use any Python machine learning packages. Application developers can simply call stored procedures with a script and even use Python and R models in the same application at the same time.
Among other innovations in SQL Server 2017, you can select the graph database in the database engine - it is useful in areas such as predictive analytics and the Internet of Things (IoT) - as well as adaptive query plans.
PS 1cloud company offers to rent additional software licenses to the server: SQL Server Web Edition, SQL Server Standard Edition, SQL Server Enterprise Edition, Microsoft Office, etc. Details here .
PPS What else do we write in our blog:
Source: https://habr.com/ru/post/327172/
All Articles