Building Applications with SQL Data Services and Windows Azure

This was a session on building applications with SQL Data Services that can reside in the Cloud.

 

• Introduction to SQL Data Services and Azure

SQL Server in the Cloud.  Azure is Microsoft’s cloud.  Relational DB in the Cloud.   You store your data on Microsoft’s Servers.

Supports common application patterns.

Logical based administration

Patterns work for SDS and SQL Server 2008

Throttling and load balancing

Limits on DB size, duration of transaction, etc.

• What is a Data Hub (Cloud)? 

  This is the idea of taking your data and bringing it into the Cloud.  This is public data source.  This will require syncing of data which can be difficult.

  Each account has zero or more servers

  Each server has one or more databases

  Each database has standard SQL Objects.

  Helps to reduce capital costs.

   

  Conclusion:  This is a neat concept, but I not sure it is practical for Weston.  I don’t think we are in the business of using a third party to avoid capital costs.