On the 6th day of Windows Azure Platform Christmas my true love gave to me the SQL Azure Database.
What is the SQL Azure Database?
The SQL Azure Database is a Windows Azure platform relational database system based on SQL Server technology and because of this provides a very familiar development model. So; as developers, you can still use familiar connection protocols like; ADO.NET, ODBC and the Entity Framework to name a few.
You can also use the standard SQL tools that you’re used to like Management Studio, Integration Services, Analysis Services and BCP. So, if you want to manage or move an existing database in the Cloud, it should be very simple.
But that’s not the only benefit of using a Cloud-based relational database system, there are more.
Let’s imagine that your server suddenly comes under some heavy workload; not to worry. SQL Azure replicates multiple redundant copies of your data to multiple physical servers to maintain data availability. But what if my server fails? Simple; SQL Azure provides automatic failover. All this without you having to manage a single thing
You can also scale up and scale down the service as your data grows or reduces and with the use of a “pay-as-you-grow” pricing model, this makes sure that you only pay for what you store.
I’ve only touched on a few benefits here, but what I wanted to show was the familiarity and ease with which you can store, manage and access data in the Cloud.
Tomorrow installment: SQL Azure - Reporting
P.S. If you have any questions, corrections or suggestions to make please let me know.