Fetching Data from SQL Azure table in Windows 7.1 [Mango] Phone using WCF Data Service

In this article, we will discuss about how to consume data from cloud [SQL Azure] in a Windows 7.1 [Mango] phone. SQL Azure and Windows 7.1 [Mango] phones are two common terms that you can hear about from many tech-savvy people. So I thought it is the right time to integrate these technologies. In this … Continue reading Fetching Data from SQL Azure table in Windows 7.1 [Mango] Phone using WCF Data Service

Different Data Base Editions in SQL Azure

There are two Data Base Editions in SQL Azure. Web Edition Relational Database includes: · Up to 5 GB of T-SQL based relational database* · Self-managed DB, auto high availability and fault tolerance · Support existing tools like Visual Studio, SSMS, SSIS, BCP · Best suited for Web application, Departmental custom apps Business Edition DB … Continue reading Different Data Base Editions in SQL Azure

SQL Azure Architecture

SQL Azure resides in Microsoft Data center provides relational database to application with four layer of abstraction. Four layers of abstraction can be depicted as below, Client Layer This layer is closest to the application. SQL Azure connects with client application with Tabular Data Stream interface in exactly the same way SQL Server does. Client … Continue reading SQL Azure Architecture