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


100MB, 1GB and 5B


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


100MB, 500MB, 1GB, 2GB


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


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.

When you attempt to create an Windows Azure SQL Database using the Custom Create option, you will be presented with the wizard as shown in screenshot 2. Screenshot 1 shows the options you need to select to get to the wizard.


After you have provided the database name, you will need to select the subscription and the edition (service tier). If you have enabled Preview Feature for your account, then you will be given the option to select a Basic, Standard or Premium tier (see Screenshot 3) in the wizard. You will have the additional option to select the performance level which is measured in database throughput units (DTUs). Based on the performance level you choose, the pricing would differ.

Next, you get to pick the maximum size and the database collation. If you have a server already created where you are hosting other Azure SQL databases, then you can pick an existing server or opt to create a new server. If you opt to create a new server, then you will be presented with the options shown in Screenshot 4.

image image

In the Create Server page, you will provide the login name and password for the administrator account and the region where the server is hosted. The region is important for two reasons:

1. You would want to pick a region where your customer/user concentration is the highest.

2. The region you pick would decide your cost as well as all regions do not have the same pricing for Azure SQL database. You would also want to be aware of the outbound data transfer rates as you will be charged for outbound data transfer once you exhaust your free limit.


The option of “Allow Windows Azure Services to Access the Server” needs to be checked if any other Azure service needs to connect to the Azure SQL database hosted on this server.

Note that any other database that you create within this server would also have the same administrator login and password and would be hosted in the same region.

After filling in the information in the two screens mentioned above, you will have a database available on Azure within a few moments! The Azure SQL database server is created with a random name and the name has a suffix of

Look  forward to future posts about how to leverage the new preview features and manage the Azure SQL database.


Azure SQL Database

Microsoft Azure SQL Database Pricing

Outbound Data Transfer Rates


One thought on “Creating the Azure SQL Database

  1. Pingback: Azure SQL Database–Firewall | TroubleshootingSQL

It is always good to hear from you! :)

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s