Azure Support

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 [...]

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

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 [...]

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 of SQL Azure, the scripts generated by SQL Server Management Studio will require some extra cleanup since not all the SQL [...]

SQL Azure Continuous Backup is one the two main methods for backing up databases which run  on  SQL Azure. Continuous Backup enables developers to backup a database on a continuous basis – as in the backup will not function as a standalone database but must be restored to the original database (in contrast to the [...]

SQL Azure Clone Backup is one of the two primary methods for backing up SQL Azure databases. Clone Backup is promised coming in H2 2010 – although there have been no announcements to date. The clone will create a single (perhaps scheduled) snapshot of a database at a point in time. The other main method [...]

So how do you know whether all the T-SQL syntaxes are working with SQL Azure? For the purpose of this example we will use the TSQL from the AdventureWorks database. Database First you need to create a database. You need to be logged in to the Master database to create a database. CREATE DATABASE AdventureWorks2008 [...]

Since the SQL Azure database services are in the cloud, you do not have to worry about high availability and scalability. SQL Azure will maintain a “Monthly Availability” of 99.9% during a calendar month. For example, you or your network administrators do not have to spend time on high availability which is taken care by [...]