Those advantages of Windows Azure SQL database

Windows Azure is Microsoft's cloud infrastructure platform, and today, cloud computing has been widely used in many ways, so it has become a major part of Microsoft's overall strategy, and as a Windows Azure SQL database (formerly known as SQL Azure), Windows Azure has developed a lot of power.

Microsoft has great expectations for azure, especially for Windows Azure SQL database (for simplicity, hereinafter referred to as SQL Azure), and it does not only appear to provide database support in cloud services, but also to create support for PB-level "large data" And even the infrastructure of all scale data.

What's the advantage of using SQL Azure compared to creating your own instance of SQL Server? Here are some key advantages, especially for those that are running SQL Server internally.

Use existing tools. Using SQL Azure can be done through sqlcmd or SQL Server Management Studio, and SQL developers should be familiar with both tools.

No administrative entities are required. You must be tired of it. Set up SQL Server, configure the database, clean up the physical server and other routine annoying work, put your database hosting after these things become someone else's work, this is a big positive. If you're starting from scratch, the advantage of this approach is even greater, and you don't need to import existing data stores into cloud services.

Out-of-the-Box high availability. Azure usually eliminates the need to build a high-availability architecture. This is true for SQL Azure as well, and any database built in it is automatically highly available.

Scalable service planning meets multiple requirements and budgets. SQL Azure Enterprise-class features may seem a bit of a fuss for relatively simple requirements, but Microsoft has taken steps to make SQL Azure attractive to both large and small business users. First, Microsoft has set up a pricing structure to support users with smaller needs; you can pay a minimum of 4.99 dollars a month for the database, and the maximum storage per database can reach 150GB.

Elastic。 This is a much-abused buzzword, but for SQL Azure it is truly true. Applications written for multiple databases can be extended with azure by adding an instance on demand. In other words, the biggest benefit of SQL Azure is not just adding or reducing the number of nodes on demand. Microsoft also provides a federal infrastructure for easier expansion, less impact, and the SQL Azure Federated Data Migration Wizard to further automate the process.

Support for non-Microsoft technologies is increasing. The more Third-party software technologies that Microsoft can support across all the different layers of azure, the more likely it is that people will use it to build applications and be compatible with the software they already use. Aside from the fact that Python, NoSQL, Java, Node.js, and PHP have been supported throughout the azure architecture, another major and critical technology specifically applied to SQL Azure is Hadoop. Hadoop (Windows Azure Hdinsight) in Azure Systems is currently only available through invitations, but its presence is significant.

You can use it through a VM if you need it. One way SQL Azure claims to be part of the overall architecture is to provide multi-level implementations. If you just need a website and database, you can choose an instance of SQL Azure for the Azure site to complete. If you need a full-fledged virtual machine (VM), you can do well--even using SQL Server instances deployed locally in virtual machines instead of SQL Azure.

Synchronization and migration tools. If you already have a set of SQL Server-stored data, you want to sync to SQL Azure or you want to do it through a passive migration of sync functionality. Using the service itself is free, and all inbound azure data will not charge any fees, so you don't have to worry about the huge cost of synchronizing the GB scale.

All existing tools for migrating data between instances of SQL Server are available. You can do this using the Microsoft Sync Framework, or you can do it using the T-SQL script, bcp tool, or SQL Database Migration Wizard (although Microsoft does not support the last one).

"Edit Recommendation"

Approaching Microsoft Style's public cloud Windows Azure Microsoft out of Windows Azure Battle China Market Microsoft Windows Azure Storage burst global failure Windows Azure supports Android applications for East Asia promotion cloud services Microsoft launches the first Hadoop Public Preview version of Windows Azure Services: "The editor of the Iris TEL: (010) 68476606"