Week Eleven Activities: Create and configure Azure SQL Database

Azure SQL Database is the relational database-as-a-service which provide high performance, secure, and reliable database facility using the Microsoft SQL server engine.

In this phase three implementation of my project, I am using Azure SQL database system to consumption and publish analyzed data from HDInsight Hadoop ecosystem. Then, Business intelligence application Microsoft Power BI will be integrated with Azure SQL  database for data visualization.

The steps of Azure SQL Database configuration:

Step1:  Select Database from the left side of user console of Microsoft Azure, click SQL Database.1.jpg

Step 2: Give the database name. In my case, I used “flighdelaydb,” select your subscription, and resource group, then click Server configuration. You will get server configuration. 2

Step 3: click “Create a new Server” and provide the following information.  Select the location that same to HDInsihgt Hadoop cluster and Azure storage account. In my case, I used “EAST US.” then click “Select.”3.jpg

Step 4: Now you need to configure elastic pool and price tier.

4.jpg

Elastic pools are the solution for managing, scaling multiple databases cost effective way. The databases in an elastic pool are on a single Azure SQL Database server and share a set number of resources and to optimize the price performance for a group of databases.

DTUs stand for Database transaction units, and eDTUs means elastic database transaction units. It measures the different performance levels and service tiers of Azure SQL database based on the amount resources utilization such as CPU, memory, I/O. The ratio amount those resources determine by the real-world OLTP workloads.

Step 5: I am not going to use the elastic pool because I need a single database. The selection of price depends on your budget, data size, and performance. I am going to use “Basic” price tier because of my demo data size less than 5 GB. If it is more than that you can choose “Standard.” The cost of the price tier is calculated monthly usages.

Step 6: Click “Create” to deploy the database. It will take 1-2 minutes to implement.

7

Step 7: click ‘create’, It will check validation of configuration. then start deployment in a second. You will get an error during validating if your configuration doesn’t match with the requirement.

8.jpg

9.jpg

Step 8: You will get a message after complete deployment successfully. 10.jpg

Step 9: Overview of configuration

11.jpg

 

Thank you 🙂

 

Advertisements

Leave a Reply

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