Tips and tutorials

As at launch in January 2010 SSMS can connect to SQL Azure, but the object browser does not work.

Ensure that you have setup the SQL Azure firewall to allow your IP to connect to SQL Azure.
Start …

SQL Azure comes with a built-in  firewall, through which all connection attempts to a SQL Azure database must pass. By  default the firewall blocks all access to the database even from your own Azure applications. …

SQL Azure Performance Tuning is a much tougher task than SQL Server. SQL Azure lacks some of the basic tools available to SQL Server DBA’s. There really isn’t too much to do tuning your SQL Azure instance as almost all the settings available for SQL Server are automatically managed by the SQL Azure platform. However, there is still some performance tuning to be done – mostly in the execution of the operations performed by the database. A major tool missing from SQL Azure is the SQL Server Profiler, despite this however there is still some optimization that can be performed on your SQL Azure queries – you can do this by either using SSMS or SET STASTICS.

This article aims to provide a brief introduction to cloud programming using Visual Studio 2010.

Earlier this week, Zane Adam announced the availability of the New AppFabric Access Control service in LABS. The highlights for this release (and I quote):

Expanded Identity provider support – allowing developers to …

Prerequisite

VS 2010 Beta
Windows AZURE SDK should be installed on the system.
Step 1

Open Visual Studio 2010 as an administrator. Select File -> New -> Cloud Service. Click on Windows Azure cloud service template. …

SQL AZURE
SQL Azure is essentially a cut down version of SQL Server and so we would expect that migrating from SQL Server to SQL Azure should be a straightforward task. However, in the first release …

Step 1
Login to your Azure portal with your live credential.  After your successful login , you can see the below screen . Just click on New Service.

Step 2
Then you need to …

In this article, I will show you how we can perform CRUD operation on AZURE table.  This article is divided into two parts.  In part 1, I am using local development fabric and …

More than a buzzword in executive meetings, cloud computing is the next big thing in the world of IT. Clouds offer an infinite amount of resources, both on demand and in pay-per-use models: computer resources …