SQL Server 2017 to add Python support

By David Smith

(This article was first published on Revolutions, and kindly contributed to R-bloggers)

One of the major announcements from yesterday’s Data Amp event was that SQL Server 2017 will add Python as a supported language. Just as with the continued R support, SQL Server 2017 will allow you to process data in the database using any Python function or package without needing to export the data from the database, and use SQL Server itself as an operationalization platform for production applications using Python code. In addition, the high-performance and distributed statistical and machine learning functions from the RevoScaleR and MicrosoftML packages in Microsoft R will be available as Python functions for use within SQL Server.

The video below provides more details on the capabilities and the underlying architecture, and includes a demo of deploying and running Python code within SQL Server 2017.

SQL Server 2017 will also be available for the first time on Linux (including within Docker containers). The new version is currently in public preview, and R and Python integration will be available for both the Linux and Windows editions. In case you missed it yesterday, check out our post on the many new features supporting R in Microsoft R Server 9.1. And for more on the many updates coming in SQL Server 2017, take a look at the official blog post linked below.

SQL Server Blog: Delivering AI with data: the next generation of Microsoft’s data platform

To leave a comment for the author, please follow the link and comment on their blog: Revolutions.

R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more…

Source:: R News

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.