Microsoft SQL Azure - SQL Server in the Cloud

JGI/Jamie Grill/Getty Images

With SQL Azure, Microsoft offers serious database users the ability to put their databases in the cloud. SQL Azure is a relational database that supports Transact-SQL using  Microsoft SQL Server Technology but allowing you to place all of the server and operating system administration tasks in the hands of Microsoft Engineers.

Features of SQL Server in the Cloud

Some of the features you'll obtain by using SQL Azure are:

  • Simplified administration, leaving the management of the database platform, operating system and hardware in the hands of others
  • Scalable resources, allowing you to quickly add or remove resources as your needs change
  • Integration with ODBC, PHP, and ADO.NET data access
  • Management through SQL Server Management Studio (using the version shipped with SQL Server 2008 R2 or later)
  • Most of the basic functionality of Microsoft SQL Server

Limitations

It's important to recognize that, while SQL Azure is a cloud-based alternative to Microsoft SQL Server, it is not the same as a hosted SQL Server environment. There are several important distinctions

  • Databases are limited to 10GB.
  • Some datatypes (specifically the CLR datatypes, which include geospatial data) are not supported
  • Vague warnings that your connection may be terminated for "excessive resource usage"

Conclusion

Overall, SQL Azure is a very interesting product and may be quite appealing to those in a specific niche seeking high-performance cloud-based databases under 10GB.

However, most web users will probably find that they can find similar pricing from various ISPs that include the cost of web hosting. Expect to see SQL Azure grow in popularity as it rolls out more scalable solutions supporting more advanced SQL Server functionality.

Format
mla apa chicago
Your Citation
Chapple, Mike. "Microsoft SQL Azure - SQL Server in the Cloud." ThoughtCo, Apr. 10, 2017, thoughtco.com/sql-server-in-the-cloud-1019831. Chapple, Mike. (2017, April 10). Microsoft SQL Azure - SQL Server in the Cloud. Retrieved from https://www.thoughtco.com/sql-server-in-the-cloud-1019831 Chapple, Mike. "Microsoft SQL Azure - SQL Server in the Cloud." ThoughtCo. https://www.thoughtco.com/sql-server-in-the-cloud-1019831 (accessed October 20, 2017).