Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Does anyone have experience with Microsoft Azure SQL services?

Posted on 2010-08-22
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 41

Assisted Solution

graye earned 2000 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 2000 total points
ID: 33503818
Are you talking about "Managed Storage Procedures"?   What is your C++ modules used for?
LVL 41

Accepted Solution

graye earned 2000 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
As managed cloud service providers, we often get asked to intervene when cloud deployments go awry. Attracted by apparent ease-of-use, flexibility and low computing costs, companies quickly adopt leading public cloud platforms such as Amazon Web Ser…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

618 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