Support CLR Stored Procedures
Thanks for your feedback. We now have the next generation of Azure SQL DB in public preview in the US and GA in Europe.
Specifically it supports CLR.
Details here http://azure.microsoft.com/blog/2014/12/11/preview-available-for-next-generation-of-azure-sql-database/ and https://msdn.microsoft.com/library/ms189524.aspx
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.
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.
We can not migrate to SQL Azure without CLR support.
Brian White commented
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.
SqlCacheDependency requires this.
I hope MS will add full CLR support.
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 Vilimek commented
Or at least allow us to create "safe" functions such as for regular expressions etc.
Mike G commented
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
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.
Chris Pietschmann commented
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.
CLR! How can one live without CLR???
Yes, CLR is very important, without CLR. It is like the SQL Azure is back to SQL 2000
Jamie Thomson commented
Yep. Supporting CLR would mean the CLR types (spatial and hierarchyid) would be open to us as well. Bring it on!