Category Archives: AZURE

I have already posted on many level 100 developers articles on SQL Azure. You can read them here. I thought if my SQL Azure blog post series does not have a post on “Connecting SQL Azure to Microsoft Access “then it cannot be called as complete post series. So I gave a try and cameContinueContinue reading “Connecting Microsoft Access to SQL Azure”

Before we will come to know, how to create X.509 certificate for Windows Azure web Role, let us understand why we need a certificate for a role? It authenticates whether an operation on an azure subscription is authenticated or not? Certificates help us for Authentication. There are two types of certificates 1. Management certificates 2.ContinueContinue reading “Windows Azure for Developers Task 11: Create X.509 certificate for Windows Azure Web Role”

There is a Session Id assigned to each connection to SQL Azure. Session Id may be very useful in debugging and can be logged by the developers. In this article, I will show “How could fetch Session Id programmatically? First step to create a class with the properties 1. Server Name 2. Login Name 3.ContinueContinue reading “Getting Session ID in SQL Azure programmatically”

A common question comes in our mind that, how to work with ADO.Net and SQL Azure? In this post, I am trying to simplify this. Assume we do have a database called School at local SQL Server and as well as at SQL Azure. Essentially we need to change only connection string in config fileContinueContinue reading “SQL Azure with ADO.Net”

Before we can begin working with AppFabric Service Bus, we need 1. Service Bus Account 2. Namespace in Service Bus Project In this post, we will walkthrough on creating a new Namespace in Service Bus project. 1. Very first we need to login to Azure portal. 2. After successful login from left tab selcet ServiceContinueContinue reading “Getting Started with Azure AppFabric Service Bus: Creating Namespace”

In this post we will add and delete firewall rules associated with Database server in SQL Azure programmatically. Read part 1 of this post here. In part 1, we fetched SQL Azure firewall rules programmatically. In this post I am going to add two functions in existing Firewall class. 1. Adding function to add firewallContinueContinue reading “Adding and Deleting SQL Azure firewall rules programmatically”

In this post we will fetch firewall rules associated with Database server in SQL Azure programmatically. First step is to create a FireWallRule class. This class contains three properties corresponds to three basic ingredient of firewall rules in SQL Azure. 1. Name of the firewall 2. Start IP address 3. End IP address FirewallRule.cs OnceContinueContinue reading “Fetching SQL Azure firewall rules programmatically”

In this post, we will fetch firewall rules from SQL Azure. Each Database server in SQL Azure is associated with one or more firewall rules. Each firewall rules have, 1. Name 2. Start IP Address 3. End IP Address Firewall rules can be fetched by querying against Master Database. To retrieve firewall rules login toContinueContinue reading “Listing Firewall rules in SQL Azure”