SQL Server vs Microsoft Azure

Which would you use and why?  Pros / Cons?

I found this article but it was written in 2010.
http://sqlmag.com/cloud/sql-server-vs-sql-azure-where-sql-azure-limited
LVL 2
CipherISAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
It depends! In which context?

For example, if you are hosting a web site on Azure, also hosting the database in SQL Azure in the same data center is very logical.

If you are having a Windows Forms or WPF application, having a local SQL server would be more logical (mostly because your performance might suffer from the Internet latency).

But once that said, there are always some exceptions to one scenario or the other.
0
CipherISAuthor Commented:
The questions I have is regards to the technical aspect.

I know Azure has the ability to scale up and down but.....

Can you write SPROCs, Triggers, UDT's in Azure?
Do all tables have to have a clustered index?
Does Azure have a reporting service like SQL Server has SSRS?
Is the architecture different than SQL Server?
Do you require Failover or high availability services when writing to SQL?

Basically, is Azure just like SQL Server but on the cloud?
0
Daniel JonesData Research AnalystCommented:
SQL Azure is a subset of SQL server which means that the some features present in SQL server won't be present in SQL Azure.

Some  limitations:
* No SQL Agent equivalent for SQL Azure. You'd have to call your single-line statement from a background task. However, if you have a Web Role already, you can easily spawn a thread to handle this in your web role without having to create a Worker Role.
* Restrictions of Stored Procedures in SQL Azure
https://blogs.msdn.microsoft.com/sajid/2010/04/22/restrictions-of-stored-procedures-in-sql-azure/
* There is no profiler available for SQL Azure
* There is no way to send an email from SQL Azure directly. You will have to use a web, worker or VM role to actually send email.

SQL Azure has some other unsupported features, you can see from here: https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Éric MoreauSenior .Net ConsultantCommented:
this is true that SQL Azure has limitations today. There were many about a year ago and they are filling the gap almost on a monthly basis to make it on par.

If you really want to go Azure but the limitations are hitting you, you can install a VM in Azure to host a full SQL Server (the very same that you would install on your own server).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.