Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Implementing SQL Azure connectivity features


SQL Azure is a relational database service in the cloud, which can be used to store business data or system data. It is like database-as-a-service for cloud applications, which is hosted by Microsoft. Its predecessor, SQL Data Services (SDS) built on architecture with full scalability, fault tolerance, and high availability features, has been enhanced to offer the relational database services on top of existing SDS architecture, named SQL Azure.

Like all other Windows Azure services in the cloud, SQL Azure is scalable and Microsoft data centers provide these services with load balancing, failover, and replication capabilities. SQL Azure services comprise three layers: infrastructure, platform, and services that run inside the Microsoft data center and the client layer from the user side. At any point in time, SQL Azure maintains three replicas of user application databases. In case one replica fails, the infrastructure and platform create a new...