asked on 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
I found this article but it was written in 2010.
http://sqlmag.com/cloud/sql-server-vs-sql-azure-where-sql-azure-limited
Microsoft SQL ServerAzure
Last Comment
Éric Moreau
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.