Home » Archive by Category

Articles in the Azure Category

SQL Azure Performance – Query Optimization
Wednesday, 16 Mar, 2011 – 18:27 | No Comment

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 …

Virtual Machine role in Windows Azure
Thursday, 17 Feb, 2011 – 15:27 | No Comment

Windows Azure now includes a Virtual Machine role that allows organizations to host their own virtual machines in the cloud.
Microsoft introduced this role as a way to ease the migration of applications to cloud computing. …

What you need to know about Windows Azure services
Wednesday, 2 Feb, 2011 – 16:10 | No Comment

Microsoft is famous for saying it’s "all in" with cloud computing, and for developers, there’s been a lot of information, code and features to sink their teeth into. But as an IT administrator, the cloud …

SQL Azure data synchronization
Thursday, 13 Jan, 2011 – 18:10 | No Comment

In my previous article, “SQL Azure migration: To the cloud and back again,” I discussed the options for moving data between local SQL Server instances and SQL Azure. In this article, we will look at more …

SQL Azure migration to the cloud and back
Thursday, 13 Jan, 2011 – 18:01 | No Comment

As SQL Azure gets more popular and widely used, users will have to develop reliable processes for migrating data to the cloud or bringing it back, either to local servers or a data warehouse on-premises. In more …

Introduction to Table Storage in Windows and SQL Azure
Wednesday, 15 Dec, 2010 – 15:15 | No Comment

In addition to SQL Azure, Windows Azure features four persistent storage forms Tables, Queues , Blobs and Drives. In this article we will focus on Tables.
Table Storage
Tables are a very interesting new storage method offered …

SQL Azure Limitations and Supported Features
Wednesday, 15 Dec, 2010 – 9:44 | No Comment

Even though SQL Azure is based on SQL Server, it includes some limitations because of its Internetavailability and cloud deployment. When you use SQL Server on-premises, the tools and client APIs havefull access to the …

Differences Between an Azure Web Role and an ASP.NET Project [FAQ]
Friday, 10 Dec, 2010 – 9:07 | No Comment

An Azure Web Role is very similar to the traditional ASP.NET project. However there are three differences in the default setup:

In an Azure Web Role, references are added to 3 assemblies. Diagnostics which contains all …

Azure CDN (Content Delivery Network) In Your App
Wednesday, 8 Dec, 2010 – 7:19 | No Comment

The Windows Azure CDN is a convenient way for application developers to minimize latency that geographically dispersed application users will experience. As of  as of February 2010, the Azure CDN is currently in CTP and …

Connect to a SQL Azure Database Using SQLCMD or SSMS
Monday, 29 Nov, 2010 – 10:39 | No Comment

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 …