Extended Stored Procedures and Azure?

Question

Are there any plans to support Extended Stored Procedures in SQL Azure?

From my understanding, Windows Azure is your own private VM. So why isn't it possible to use Extended Stored Procedures there?

Thanks.

Answer 1

Hello.

I don't know if there are any plans  about extended stored procedures but i think you can offer this idea on this feature on this great site:

http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting

Answer 2

Thanks.  I notice Azure also does not support CLR. I can't imagine that there will be widespread acceptance of SQL Azure without it.

Answer 3

Hello.

Yes, Azure does not support CLR yet. But SQL Azure has a 3-month development process and every 3 month (as far as i know) they releasing most popular features (as i understand, they choose most popular features from the site above).

So vote for features and maybe they will release it on their next iteration.

Answer 4

Thanks, I submitted the request.  Does Windows Azure only use SQL Azure, or can you load, say, SQL Express on Windows Azure?

Answer 5

Hi,

In fact, Windows Azure Compute gives you private VMs but SQL Azure runs in independent boxes (not inside your VMs).

SQL Azure it's a service that you can use and not a service that runs inside your VM's.

Windows Azure Compute VM's are considered statless because if there was a problem with one VM, Azure will fire up another instance and all data in the first VM will be lost. In fact you can install SQL Azure Express in the VM but you can also lose that data at anytime. The workaround could be the use of Windows Azure Drive but... could be some issues regarding performance or costs... SQL Azure is the recommended way to go...

---

If you found this post useful, Please "Mark as Answer" or "Vote as Helpful". Best Regards.