How can we improve Windows Azure Data Management: SQL Database?

Support CLR Stored Procedures

464 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 →
    Neil WeicherNeil Weicher shared a merged idea: Support Extended Stored Procedures.  ·   · 
    umpahumpah shared a merged idea: support SAFE CLR please  ·   · 

    12 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...
      • 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.

      • WcfMeWcfMe commented  ·   ·  Flag as inappropriate

        We need CLR for Regular Expression parsing. If there will be no CLR in Azure, we need something TSQL-native. Regular Expressions are not new technology...

      • Jan VilimekJan Vilimek commented  ·   ·  Flag as inappropriate

        Or at least allow us to create "safe" functions such as for regular expressions etc.

      • Mike GMike G commented  ·   ·  Flag as inappropriate

        Aggregate functions are the things I would most like to see in terms of CLR support. These have given use huge perf gains for some types of query and it's a big blocker for pueruaging my collegues to even look at SQL azure

      • AlexSM13AlexSM13 commented  ·   ·  Flag as inappropriate

        I would like to see realised "full CLR support":
        CLR SP, CLR UDF, CLR Types, and possibility to write custom aggregate functions, based on CLR.

      • crpietschmanncrpietschmann commented  ·   ·  Flag as inappropriate

        You can now use the SQL Spatial data types with SQL Azure database. It would still be nice to have the ability to use the SQL CLR just as in SQL Server.

      • Jamie ThomsonJamie Thomson commented  ·   ·  Flag as inappropriate

        Yep. Supporting CLR would mean the CLR types (spatial and hierarchyid) would be open to us as well. Bring it on!

      Feedback and Knowledge Base