Chapter 12. Managing SQL Azure Accounts and Databases
SQL Azure is the SQL Server team's name for a set of highly scalable cloud services based on a customized version of SQL Server 2008 and related services hosted in Microsoft data centers. SQL Azure is intended to provide the capabilities of an enterprise-grade data center without the capital cost of its physical facilities or the operating expenses for its management or maintenance, as well as server and database license fees. SQL Azure provides high availability by replicating a total of three redundant copies of your data to separate physical servers. SQL Azure achieves scalability while maintaining transactional consistency by partitioning data into individual 10GB or smaller databases.
When this chapter was updated in January 2010, only the first of these services—SQL Azure Database (SADB) v1, a scalable and available relational database—had been released as a commercial product. Ultimately, SQL Azure will consist of the following services:
SQL Azure Database to provide core SQL Server database capabilities (released during PDC 2009).
Azure Data Sync to enable synchronizing cloud and on-premises SQL Server and SQL Azure databases with the Microsoft Sync Framework. Chapter 13 describes Azure Data Sync.
Business Intelligence (BI) and Reporting Services (RS) with no current CTP or release timetable.
This chapter concentrates on creating a SQL Azure account, getting connected to an SADB v1 server, and creating user databases with ...
Get Cloud Computing with the Windows® Azure™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
