<p><div><div><div><div data-show-faces="false" data-height="21" data-width="100" data-layout="button_count" data-send="true" data-href="https://www.r-bloggers.com/r-now-supported-in-azure-sql-database/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="https://blog.revolutionanalytics.com/2018/11/r-support-in-azure-sql-database.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p><a rel="nofollow" href="https://docs.microsoft.com/azure/sql-database/?WT.mc_id=Revolutions-blog-davidsmi" target="_blank">Azure SQL Database</a>, the database-as-a-service based on Microsoft SQL Server, now <a rel="nofollow" href="https://cloudblogs.microsoft.com/sqlserver/2018/11/07/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database/" target="_blank">offers R integration</a>. (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 <a rel="nofollow" href="https://azuremarketplace.microsoft.com/en-us/marketplace/apps/Microsoft.SQLServer2016SP2StandardWindowsServer2016?tab=Overview" target="_blank">virtual machine</a>, 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 <a rel="nofollow" href="https://docs.microsoft.com/learn/modules/provision-azure-sql-db/?WT.mc_id=Revolutions-blog-davidsmi" target="_blank">Microsoft Learn module</a> is a good place to start.)</p>
<p>You can find <a rel="nofollow" href="https://docs.microsoft.com/azure/sql-database/sql-database-connect-query-r?WT.mc_id=Revolutions-blog-davidsmi" target="_blank">detailed documentation on using the R integration here</a>, 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 <a rel="nofollow" href="https://docs.microsoft.com/sql/advanced-analytics/what-is-sql-server-machine-learning?view=sql-server-2017&WT.mc_id=Revolutions-blog-davidsmi" target="_blank">standalone SQL instances</a> (with the exception that Python is not yet supported on Azure SQL Database), so the tutorials and guides there apply here as well.</p>
<p>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.</p>
<p>SQL Server Blog: <a rel="nofollow" href="https://cloudblogs.microsoft.com/sqlserver/2018/11/07/announcing-preview-of-machine-learning-services-with-r-support-in-azure-sql-database/" target="_blank">Announcing: Preview of Machine Learning Services with R support in Azure SQL Database</a></p>
</div>
	<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="https://blog.revolutionanalytics.com/2018/11/r-support-in-azure-sql-database.html"> Revolutions</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a rel="nofollow" href="https://www.r-project.org/" title="The R Project for Statistical Computing">R</a> news and <a rel="nofollow" href="https://www.r-bloggers.com/search/tutorial" title="R tutorials">tutorials</a> on topics such as: <a rel="nofollow" href="https://www.r-bloggers.com/search/data%20science" title="Data science">Data science</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data" title="Big Data">Big Data, <a rel="nofollow" href="https://www.r-users.com/" title="R jobs">R jobs</a>, visualization (<a rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2" title="ggplot and ggplot2 tutorials">ggplot2</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/boxplot" title="Boxplots using lattice and ggplot2 tutorials">Boxplots</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/map" title="Maps and gis">maps</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/animation" title="Animation in R">animation</a>), programming (<a rel="nofollow" href="https://www.r-bloggers.com/search/RStudio" title="RStudio IDE for R">RStudio</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/sweave" title="Sweave and literate programming">Sweave</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX" title="LaTeX in R">LaTeX</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/SQL" title="SQL and databases">SQL</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/eclipse" title="Eclipse IDE for R">Eclipse</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/git" title="git and github, Version Control System">git</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/hadoop" title="Large data in R using Hadoop">hadoop</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping" title="Web Scraping of google, facebook, yahoo, twitter and more using R">Web Scraping</a>) statistics (<a rel="nofollow" href="https://www.r-bloggers.com/search/regression" title="Regressions and ANOVA analysis tutorials">regression</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/PCA" title="principal component analysis tutorial">PCA</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/time+series" title="Time series">time series</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/trading" title="finance trading">trading</a>) and more...
<img width="1" alt="" src="http://feeds.feedburner.com/~r/RBloggers/~4/80UHdv7vU-A" height="1"></a></div>