R now supported in Azure SQL Database

November 28, 2018
By

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

Azure SQL Database, the database-as-a-service based on Microsoft SQL Server, now offers R integration. (The service is currently in preview; details on how to sign up for the preview are provided in that link.) While you've been able to run R in SQL Server in the cloud since the release of SQL Server 2016 by running a virtual machine, Azure SQL Database is a fully-managed instance that doesn't require you to set up and maintain the underlying infrastructure. You just choose the size and scale of the database you want to manage, and then connect to it like any other SQL Server instance. (If you want to learn how to set up an Azure SQL database, this Microsoft Learn module is a good place to start.)

You can find detailed documentation on using the R integration here, where you can learn how to apply R functions to tables from a stored procedure, execute R from a local RStudio client on the remote database, and add new R packages to the R instance in the SQL database. The interface is the same as for standalone SQL instances (with the exception that Python is not yet supported on Azure SQL Database), so the tutorials and guides there apply here as well.

For more details on the new R integration on Azure SQL Database, including how to sign up for the preview, check out the blog post at the link below.

SQL Server Blog: Announcing: Preview of Machine Learning Services with R support in Azure SQL Database

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...



If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Search R-bloggers


Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)