Essential Guide

Evolution of Windows Azure SQL Database

A comprehensive collection of articles, videos and more, hand-picked by our editors

SQL Azure

SQL Azure is Microsoft’s cloud database service.

SQL Azure is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to store relational data in the cloud and quickly scale the size of their databases up or down as business needs change. Data is hosted, managed and provisioned in Microsoft data centers.

Organizations can build applications on-premises and move them to SQL Azure or build them on Windows Azure and keep the data in the cloud. SQL Azure supports SQL Server’s Transact-SQL (T-SQL) query language, offers built-in support for high availability and fault tolerance and allows for data to be synchronized between on-premises SQL Server and cloud databases.

Database analysts have pointed out a few important differences between SQL Azure and SQL Server. For example, SQL Azure doesn’t support all T-SQL commands, SQL Server data types like XML or functions such as cross-database joins, and the maximum database size currently is just 50 GB. The current release also does not perform scheduled backups and restores, though Microsoft has said this will be addressed in future releases.

This was first published in October 2011

Glossary

'SQL Azure' is part of the:

View All Definitions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Essential Guide

Evolution of Windows Azure SQL Database

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

File Extensions and File Formats

Powered by:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close