How can we improve Azure SQL Database?

Enable SQL Service Broker in SQL Azure

Service Broker should be available in Windows Azure.

283 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    firesnakefiresnake shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    TangalaiTangalai shared a merged idea: Support s  ·   · 

    15 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • IvanHIvanH commented  ·   ·  Flag as inappropriate

        We use SQL dependency in asp.net for caching database data. Maybe it is not necessary and can be replaced by other mechanism, but we develop an application and this is part of it. What I need is a kind of smooth transition and even ability to work against normal SQL or Azure. Otherwise there is all the time the question whether Azure is worth the necessary effort.

      • Stephen DillonStephen Dillon commented  ·   ·  Flag as inappropriate

        Have you considered Azure's IAAS offer instead of SQL Azure? There is a Windows Azure Queue capability as well as Topics and Subscriptions.

        Regarding SQL Azure, a.k.a. SQL Database circa 2013, it is not "SQL Server". It is a "NewSQL" database, sometimes also referred to as a Service Database, that allows for horizontally scalable relational databases within the Windows Azure. It is fitting that the role of the SQL Broker is not implemented when using SQL Azure by its very nature of the Cloud.

        If you were to use Azure's IAAS (Infrastructure as a Service) offer then you could implement an Azure VM within the Cloud. You will lose the SQL Azure scalability and retain the SQL Broker messaging.

      • Richard KiessigRichard Kiessig commented  ·   ·  Flag as inappropriate

        +1 for SqlDependency. Caching is that much more important in a multi-tenant environment like SQL Azure / Windows Azure -- and query notifications enable much more efficient caching in many cases, even across multiple web app instances.

      • alikolahdoozanalikolahdoozan commented  ·   ·  Flag as inappropriate

        Hi

        We need something like a messaging system on the Azure.Sometimes a query is heavy and we need to run it of the server,but we do not like to wait and we need to close the app and see the result later so it is necessary.

        Regards
        Ali.

      • stakmurstakmur commented  ·   ·  Flag as inappropriate

        Without service broker on azure, it forces us to use AWS windows instances since we cannot duplicate the functionality any other way in azure. Since there is total silence on a roadmap for ssb on azure, AWS is our current plan forward.

      • fastmikefastmike commented  ·   ·  Flag as inappropriate

        ssb transport and dialog security should be part of azure...real advantages would be realized if this was implemented!!!

      • Jamie ThomsonJamie Thomson commented  ·   ·  Flag as inappropriate

        PL,
        If I can access AppFabric Service Bus using T-SQL, then yes. If not, no.

        Guess which it is!! :)

        Besides, queues in the DB offer benefits over Service Bus such as being backed up with the DB. Not saying Service Bus is not valuable but its not an either/or - both are suited to certain scenarios.

      • PLPL commented  ·   ·  Flag as inappropriate

        Does Azure AppFabric Service Bus not meet the scenario requirements for those folks looking to use SErvice Broker?

      Feedback and Knowledge Base