Archive | Articles RSS feed for this section

SQL Azure Performance – Query Optimization

SQL Azure Performance Tuning is a much tougher task than SQL Server, as I noted in the Azure Report Card – 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 [...]

Read more

Windows Azure Report Card – Year One

OK, Windows Azure isn’t a year old yet (it only came out of Beta in February) but it is almost year since it was made widely available and demoed at PDC 2009. So before PDC 2010, its a good time to reflect on the past year of Azure with a report card for Azure to [...]

Read more

SQL Azure Backup Using Database Copy

Backup is currently a major gap in the SQL Azure product, but with support for Database Copy TSQL command has given at least one option for directly backing up a SQL Azure database by copying a source Azure database to a newly created  Azure database. The TSQL command structure below provides will produce a copy [...]

Read more

Visual Studio LightSwitch Beta Release – Simple Authoring Tool For Azure Apps

Visual Studio LightSwitch Beta has just been released (download it here). LightSwitch is a tool for rapidly developing data-centric business applications. LightSwitch apps can be deployed on a variety of platforms – as WCF/SQL Server desktop apps, Silverlight/SQL Server web apps and also Windows Azure/SQL Azure apps. Note that Azure deployment is not available in Beta 1, [...]

Read more

Windows Azure CDN Locations

The Azure CDN serves data which is cached at different global ‘edge’ locations. Currently, there are 22 CDN locations:

Read more

Windows Azure CDN Pricing

The Azure CDN is priced in two tiers: $0.15 per GB for data from European and North American locations. $0.20 per GB for data from other locations. In addition there is a flat charge of $0.01 per 10,000 transactions. The CDN works by caching content at its 20 worldwide ‘edge’ locations, the first time that [...]

Read more

Azure Pricing vs Amazon AWS Pricing Comparison

How does Azure stack up against its main rival, Amazon, in pricing? Compute Instances The standard compute instances sizes are very similar on both platforms – Small (1 core processor, 1.7GB RAM) , Large (4 core processors, 7GB RAM), Extra Large (8 core processors, 15GB RAM ). The only differences being that Azure offers slightly [...]

Read more

Windows Azure Review

This review is an update of  my first impressions of Azure I wrote back when it first launched. Having used SQL and Windows Azure for two months since its full release I thought it would be best to write a updated review (especially since there have been a few updates to Azure since the February [...]

Read more

Windows Azure Development Fabric (Dev Fabric)

The development fabric is a high-fidelity simulation of the Windows Azure cloud environment on a local development. The development fabric is designed for developing  and testing  and all Windows Azure apps should be fully tested on the dev fabric before being deployed. The development fabric UI  can be started in any of the following ways: Debugging [...]

Read more

Azure Virtual Machine ( VM ) Sizes

VM (Virtual Machine) sizes in Azure can be configured in Visual Studio by double clicking the relevant Role and selecting the VM size from the dropdown: Azure has four predefined VM’s : Small: 1 core processor, 1.7GB RAM, 250GB hard disk  - $0.12 per hour Medium: 2 core processors, 3.5GB RAM, 500GB hard disk – [...]

Read more