How can we improve Azure SQL Database?

Support CLR Stored Procedures

811 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…)
    Lev NovikLev Novik shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous shared a merged idea: sql azure will support CLR stored procedures  ·   · 
    Dave HutchingsDave Hutchings shared a merged idea: Service Bus and ability to create a brokered message  ·   · 
    Neil WeicherNeil Weicher shared a merged idea: Support Extended Stored Procedures.  ·   · 
    GETMOREGETMORE shared a merged idea: allow use of regular expressions and other usefull CLR methods  ·   · 
    umpahumpah shared a merged idea: support SAFE CLR please  ·   · 
    anonymousanonymous shared a merged idea: Add support for CLR Integration  ·   · 

    29 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...
      • Jay KiddJay Kidd commented  ·   ·  Flag as inappropriate

        Hi bdean_zap, unfortunately CLR is being discontinued due to security threats...

        Received this email early April 2016:

        In an effort to protect the security of our customers, we have proactively suspended the use of user-defined SQL CLR in Azure SQL Database.

        My name is Joachim Hammer, and I’m a Principal Security Program Manager for the Azure SQL Database service.

        I’m notifying you of an important change we’re making to SQL Database. If you’re not using SQL Common Language Runtime (SQL CLR) in SQL Database or have no plans for using it, no further action is needed on your part.

        We’ve determined that there is a security risk with user-defined SQL CLR in SQL Database. There have been no known exploits to date. In an effort to help protect the security of our customers, we have proactively suspended the use of user-defined SQL CLR. This means that user-defined SQL CLR will no longer work. We’ll update you within six months with a timeline for bringing back SQL CLR.

        Your existing SQL CLR assemblies hosted in SQL Database will continue to work until April 15, 2016. If you require your existing SQL CLR assemblies, please contact me.

        We’re committed to minimizing the impact of this change on your applications and business.

        Thanks for your understanding,
        Joachim Hammer

      • Jay KiddJay Kidd commented  ·   ·  Flag as inappropriate

        If the new Azure CLR feature only supports safe assemblies, does that mean any CLR aggregates that require Format.UserDefined (e.g. binary serializers) for purposes like VerticalConcatDistinct will not be supported? :o

      • wyx1999wyx1999 commented  ·   ·  Flag as inappropriate

        Long waiting CLR feature is coming, but only support safe assemblies, so disappointed

      • Anonymous commented  ·   ·  Flag as inappropriate

        Great news! Thanks for the update. This means we can revisit the migration to Azure again this year.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I use CLR for our own aggregate functions like concatenate() and concatenatedistinct(), as well as Regex functions and Levenstein distance.
        Without CLR we would have to rewrite a lot of our code. It's like going back to SQL 2000.
        So we are not porting our solution until we have CLR.

      • TerryTerry commented  ·   ·  Flag as inappropriate

        To prove how important this is, we've just christened our child "CLR"

      • Jimi  JJimi J commented  ·   ·  Flag as inappropriate

        CLR Triggers and SPs are very critical for the overall performance of our application. Hence, we can't move to SQL azure.

      • Anonymous commented  ·   ·  Flag as inappropriate

        CLR is the only reason for us at this point to stick to on-premises. I wish Microsoft would consider adding CLR to Azure.

      • Henri KoppenHenri Koppen commented  ·   ·  Flag as inappropriate

        I understand the CLR is complex in a multi-tenant environment, and with worker roles it's fairly easy to work around, but I use CLR a lot (template replacements, regex) so i'd love to have it!

      • AndrewAndrew commented  ·   ·  Flag as inappropriate

        The only way to get real regex functionality. In fact why don't you just add in one module as a clr that has a regex match function since that's the main reason most people that I talk with use it.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Seems noone from SQL Azure want to talk about the adding back of CLR, maybe they have big issue to do that, and they haven't figured it out how to do it.

      • Brian WhiteBrian White commented  ·   ·  Flag as inappropriate

        Really sad to see it isn't supported. I just came across a situation perfectly solved by CLR and I was hoping to use SQL Azure as my data back end, this is a dissapointment.

      ← Previous 1

      Feedback and Knowledge Base