How can we improve Azure SQL Database?

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

361 votes
Sign in
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Veerendra Thati shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: oidc
Signed in as (Sign out)
  • JayRubDub commented  ·   ·  Flag as inappropriate

    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"

  • Eddie Montes commented  ·   ·  Flag as inappropriate

    Would be great to have this. It's a must. Many simply things could be done with this integration.

  • Nellie Gustafsson commented  ·   ·  Flag as inappropriate

    Hi everyone,

    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, if you are willing to share some feedback on specific requirements I am investigating.


  • Erik A. Brandstadmoen commented  ·   ·  Flag as inappropriate

    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.

  • 増谷修 commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base