Managing Core SQL Server 2008 R2 Technologies - Microsoft SQL Server 2008 R2 Administration - page 185

The SQL Server 2008 R2 StreamInsight installation program installs the following on
your machine:
F The SDK to develop StreamInsight applications and adapters
F The StreamInsight Event Flow Debugger for debugging StreamInsight applications
F The runtime libraries for StreamInsight
F The platform libraries in the form of a set of DLLs
F The documentation and Readme file
F The StreamInsight host, optionally registered as a Windows Service
F The StreamInsight Event Flow Debugger tool
F The SQL CE installation package (required for StreamInsight servers that use the SQL
CE-based metadata store)
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 database to maintain the three replicas, making
them available at any point in time.
SQL Azure doesn't provide the features such as Service Broker, CLR and so on in SQL Server,
but provides the minimum features required to deploy and maintain the database. In this
recipe, we will go through the important steps to implement SQL Azure's connectivity features
to ensure uninterrupted data access facilities.