Does anyone have experience with Microsoft Azure SQL services?

Posted on 2010-08-22
Last Modified: 2014-11-12
Hi Experts,

I want to give my application stability and robustness but I am not seeing the limitations on service on the MS website.

1) is the Azure service a sandboxed or shared implementation? I need to be able to take my C++ extended procedures where ever we go.

2) Is the product overkill for a small shop with minimal traffic?

Question by:dilithiumtoys_dot_com
  • 3
  • 2
LVL 41

Assisted Solution

graye earned 500 total points
ID: 33501482
There's a lot more to Azure than just a "hosted SQL Service".   If you're starting small, then you mibght be better off with just a self-hosted web service (with an SQL backend).  Internal customers could hit the SQL server directly, and External clients will hit the web service.
Azure would come in if you needed guarnteed uptime, redundancy, load sharing, globalization, etc...

Author Comment

ID: 33503718
If I were to go to Azure, do you know what limitations are on it? Can I use my C++ modules?
LVL 41

Assisted Solution

graye earned 500 total points
ID: 33503818
Are you talking about "Managed Storage Procedures"?   What is your C++ modules used for?
LVL 41

Accepted Solution

graye earned 500 total points
ID: 33503851
Oops, I see where you did say "extended stored procedures"... sorry about that.
So, the answer is NO... the version of SQL server for Azure does not support extended stored procedures. 

Author Comment

ID: 33504831
Bummer :( So that is out then

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
best counters for cpu high usage 3 25
Sql Stored Procedure 65 26
sql 2014,  lock limit 5 29
SQL Server - Set Field Values ito Zero Based on Related Table 4 22
In the market for a new backup solution for Windows Server 2016? Follow these guidelines to get the most bang for your buck.
Many CHPs use the buzzword ‘Cloud Hosting’ to sell the idea of reliability. Most consumers have the opinion that cloud hosting is easily scalable and can handle just about anything. Further, most CHPs are not transparent and hide the underlying arch…
Viewers will learn how the fundamental information of how to create a table.
Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question