Creating the Azure SQL Database

In this post, I shall talk about the Microsoft Azure SQL Database. There are five service tiers: Basic, Standard, Premium, Web, and Business. Web and Business service tiers (editions) are being retired over the course of 12 months, effective April 24, 2014.

The maximum sizes available are:

Service Tier

Max Sizes available

Web

100MB, 1GB and 5B

Business

10GB, 20GB, 30GB, 40GB, 50GB, 100GB, 150GB

Basic

100MB, 500MB, 1GB, 2GB

Standard

100MB, 500MB, 1GB, 2GB, 5GB, 10GB, 20GB, 30GB, 40GB, 50GB, 100GB, 150GB, 200GB, 250GB

Premium

100MB, 500MB, 1GB, 2GB, 5GB, 10GB, 20GB, 30GB, 40GB, 50GB, 100GB, 150GB, 200GB, 250GB, 300GB, 400GB, 500GB

If you want to try the Preview service tiers, then you need to first enable the preview feature, New Service Tiers for SQL Databases, for your Azure account.

Continue reading

Setting up SQL Server on Azure for testing

I recently had the need for testing out a setup program which installs database components, integration services packages and reporting services reports. Setting up a machine like this would be really quick if you have Hyper-V installed and a VHD already pre-created with a SQL Server image. What if you do not have that handy and need to carry out your testing. This is what Microsoft Azure Virtual Machines comes to the rescue.

I used my Azure subscription to create a virtual machine for my testing. In this blog post, I will walk you through the steps for setting up a SQL Server virtual machine for testing purposes!

Continue reading