First of all I would like you to think of your response for below questions.
Are you a Database administrator?
Do you have headaches with hosting your own Database server?
Are hosting providers giving you hard time with limited capacity and bandwidth?
Now if your answer is YES to all of above, I’m gonna show you that you don’t have to worry about that anymore. Windows Azure provides a powerful data platform called Windows Azure SQL Database (formerly SQL Azure) and it is a fully managed relational database service. It offers flexible manageability, built-in high availability, predictable performance, and supports scaling. No matter whether your database requirement is small or large, Windows Azure provides excellent plans for dedicated database hosting in a scalable manner.
You can either create a Azure VM with SQL or use this service to manage your hosted databases. If you want to skip all the hassle with configuring a VM then this is your toy.I had a requirement to move a hosted SQL database to Azure. Well SQL is not my area of expertise so I thought it would be a nightmare. Guess what! I was totally wrong.
Here is what I’ve done to achieve this challenge. But keep in mind I did this by restoring the hosted database on on-premise SQL server as my service provider doesn’t support Azure. Also I had to re-create the user logins and mappings (If you your SQL it’s basically creating the users and giving them proper permissions as required). You can pretty much manage everything from SQL Management Studio (2012 only) and if you need to perform administrative tasks you can easily do them the Azure Management Portal itself.
WELL WHAT ABOUT THE COST?
Actually when I compared the cost with hosting providers, Azure seems to be in the middle, but the features and flexibility worth the pennies. You can find additional information from here about SQL Azure.