R for Azure SQL DB
It would be great if SQL Server R Services feature of SQL Server 2016 comes to Azure SQL DB as well. I see a great potential for this integration and would enable advanced analytics scenarios on PaaS seamlessly
This is currently under review (meaning we see the benefit, but don’t have a time frame to share just yet). Thanks
Alberto Morillo commented
This feature has been released on February 11, 2019. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-r
I was told by a Microsoft employee the following today....
"We are close to offering better ML integration in Azure SQL Database, but it’s not possible to mention specific dates. When the ML integration does arrive, it will be R first, and then Python"
Allan Wei commented
It is block our project move to cloud.
This issue block move up sql database to azure sql database
Eddie Montes commented
Would be great to have this. It's a must. Many simply things could be done with this integration.
Alberto Morillo commented
There is limited support for R in Azure SQL Database: available only in West Central US, in services created at the Premium tier. For more information, please read the following documentation: https://docs.microsoft.com/en-us/sql/advanced-analytics/what-s-new-in-sql-server-machine-learning-services?view=sql-server-2017#azure-sql-database-roadmap
Nellie Gustafsson commented
We are working intensely to enable SQL Server Machine Learning Services in Azure SQL DB. Our goal is to launch a preview with R during this spring.
I am very interested in getting in touch with you to understand your requirements better. Please fell free to reach out to me on firstname.lastname@example.org, if you are willing to share some feedback on specific requirements I am investigating.
Erik A. Brandstadmoen commented
For us that is on the SQL Azure platform, the capabilities when compared to SQL on-prem are very limited when it comes to Machine Learning support. SQL Server 2016 got lots of R capabilites, where you can run R scripts in-database. Now, with SQL Server 2017, Python support is added too. But we don't see this functionality being introduced in SQL Azure.
We are building more and more machine learning into our solultion, and using R, exposes via a REST endpoint. Today, we use AzureML for this, which is OK, but not really the best solution when it comes to a pure R solution.
It would be great for us if we could run our R scripts in-database in SQL server, as I understand you can now do in SQL Server on-prem, to avoid the complexity when it comes to error handling, community support (the intersection of people using AzureML and people making enterprise application is extremely small), speed (AzureML prediction is dead-slow compared to e.g. local dev box with Microsoft R Open), etc.
Any updates on this?
That's very important to provide R batch run on Azure data pipeline. We need managed service to deal with R rather than RServer or Power BI.
What is the ETA for Azure SQL to run R code? Q1, Q2, or Q3 2016??