MS Azure : Create Azure SQL Database using Single Database Model

Create Azure SQL Database

To create new Azure SQL Database follow the below steps:
Step 1 : Login to Azure Portal https://portal.azure.com with your credentials.

Step 2 : Once you Logged In successfully, portal will look like below snapshot.
From the left pane, you have to find out SQL databases as highlighted with red block in below snapshot.

Step 3 : Once you clicked on SQL databases, it will show you below screen and to create new SQL database, click on Add button as highlighted below.

Step 4 : Once you clicked Add button, it will prompt a new window to provide basic information to create new SQL database:
1. Database name : provide database name
2. Subscription : This is the drop box, Choose from the available subscription created by you.
3. Resource group : This is radio box, two options Create new or Use existing and Select the resource group.

4. Select source : This is drop down with 3 options, Choose from options 1. Blank database 2. Sample 3. Backup

5. Server : Select the server, once you clicked it will give you the option to choose from the list of available server or either create new server.

6. Pricing tier : Once you click, it will you all options to choose your pricing tier for the database.

7. Collation : Choose the collation, by default its SQL_Latin1_General_CP1_CI_AS.
Once provided all required information, click Create button. It will start the new SQL database deployment.

Step 5 : Once deployment successfully completed then click on Refresh button, it will shows the database under the list of SQL databases on the portal as shown below:

Choose the database to know the properties/settings of the SQL database, it will give you the screen as below

That's it!! Only in few minutes Azure SQL Database is ready to use.