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.

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.

image

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.

image

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 database.windows.net.

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

Reference:

Azure SQL Database
http://azure.microsoft.com/en-us/documentation/services/sql-database/

Microsoft Azure SQL Database Pricing
http://azure.microsoft.com/en-us/pricing/details/sql-database/

Outbound Data Transfer Rates
http://azure.microsoft.com/en-us/pricing/details/data-transfers/

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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