Billing in SQL Azure

1. Web edition databases are billed at the 1GB rate for databases below 1GB of total data or at 5GB rate for databases between 1GB and 5GB size. 2. Business edition databases are billed at 10GB increments (10GB, 20, 30, 40 and 50GB). In a particular day billing is done on the pick DB size.ContinueContinue reading “Billing in SQL Azure”

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 DBContinueContinue reading “Different Data Base Editions in SQL Azure”

Windows Phone 7.1 [Mango] Beta released

I’m pleased to announce that the beta release of the Windows Phone Developer Tools that support Mango will be available for download today: Matt Bencke General Manager, Windows Phone Developer and Marketplace Experiences Note: I took above image and statement from http://windowsteamblog.com This was one of the most waited releases. You can download it fromContinueContinue reading “Windows Phone 7.1 [Mango] Beta released”

Presented at Microsoft Mondays

On 16th May 2011, I presented at Microsoft Mondays program. About Microsoft Monday: This is a program in between Microsoft and Mahindra Satyam. All the participants were from Mahindra Satyam Topic: WCF REST and DATA Services Time: 11 am to 1 pm Date: 16th May 2011 Location: Virtual Training [Taken from Microsoft Pune office] DemoContinueContinue reading “Presented at Microsoft Mondays”

WCF REST Service with JSON Data

In this post I will show you working with WCF REST Service with JSON type of Data. I will discuss both POST and GET operation on data type JSON . Creating Service I have written much post on creating basic WCF REST Service. Please refer them if required. WebGet Method Let us create a GetContinueContinue reading “WCF REST Service with JSON Data”

Hosting WCF REST Service in IIS with HTTPS

In earlier post I discussed Exposing WCF REST Service over HTTPS. Major limitation on service created in last post was its self-hosted nature. In this post, I will take same service forward and host in IIS. So at the end of this post, you would able to host WCF REST Service in IIS with HTTPS.ContinueContinue reading “Hosting WCF REST Service in IIS with HTTPS”

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. ClientContinueContinue reading “SQL Azure Architecture”

Federation in SQL Azure

Federation is introduced in SQL Azure for scalability. Federation helps both admin and developers to scale data. It helps admin by making easier in repartitioning and redistributing of data. It helps developers in routing layer and sharding of data. It helps in routing without application downtime. Federation is basic scaling objects in SQL Azure Database.ContinueContinue reading “Federation in SQL Azure”

Exposing WCF REST Service over HTTPS

In this post, I will explain; how could we expose a WCF REST Service over secure HTPP (HTTPS)? Essentially there are three steps involved 1. Create a certificate or use a third party provided certificate 2. Configure HTTPS in IIS 3. Configure webHttpBinding to use transport level security Create Certificate To expose a service overContinueContinue reading “Exposing WCF REST Service over HTTPS”

Getting current Authentication information on WCF REST Service

Sometime you may have a requirement to tell your client what type of authentication scheme you are applying on your WCF REST service. In this post I will show you, “How could you expose authentication scheme information as part of your service? “ To start with let us create Self Hosted WCF REST Service. BesidesContinueContinue reading “Getting current Authentication information on WCF REST Service”