In this chapter, we have learned that Windows Azure SQL Database is a scalable cloud database service with high availability built on SQL Server technology. No installation, configuration, or maintenance relieves us from the heavy administration burden, so that we can focus on the application itself. We also looked at the ability to use your SQL Server expertise in the cloud variant and saw that there is no steep learning curve to work with SQL Database.
We saw how to set up a SQL Database environment in a specific region. Some guidelines and best practices have also been described along with the way to work with SQL Database from the portal environment.
Data Sync is the cloud service information synchronization service that works even in a bidirectional manner to keep databases all around the world in sync with each other. It is also possible to synchronize between on-premise and cloud-based databases, and all this can be done by configuration—no additional programming is needed....