Setup And Connect To Azure SQL

Introduction

Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as Service.

Managed database services supports backup, HA (high availability), and scalability of the database. Azure SQL uses SQL Server 2016 codebase and is compatible with SQL Server 2014 and most of the features in SQL 2016.

Pricing

Azure SQL database can be setup as Standalone database or an Elastic database pool (allows multiple databases to share storage and compute the resources). It is priced in three tiers – Basic, Standard, Premium.

Basic - Can be used for small database. It supports single active operation at a given time. Best suited for development, testing applications
Standard - More frequently used option. Supports multiple concurrent queries. Mostly used along with web applications
Premium - Supports many concurrent users at a time. Designed for mission critical applications.

Create Azure SQL (Azure Portal)

Creating Azure SQL from Azure Portal is few simple clicks and helps to setup your Azure SQL in a few minutes.

Please note, the old portal does not support creation of any Data Services now a days.

Microsoft Azure SQL Database

Creating Azure SQL is only supported from New Azure Portal.

Login to New Azure Portal.
Click "New" button from top left corner.
Select "Databases".
Select "SQL Database".

Fill in the SQL Database details as below,
1. Database name - Name of your Azure SQL Database. E.g. sampleSQLDB
2. Subscription - Select any of your MSDN subscription
3. Resource Group - Create a new resource group or use any of the existing.
4. Source - You may choose to create a blank database of any predefined database (e.g. Adventure Works)

Click Create a new server

Fill in the SQL server (logical server) form as below,
1. Server Name - Any globally unique name
2. Server admin login - Any valid name (e.g. user1)
3. Password - Any valid password
4. Location - Select any location for hosting SQL Server. Preferably select any location near to your location or same location where your web application is deployed.
When finished, click Select.
Click Pricing tier to specify the service tier and performance level for your new database. Use the slider to select 20 DTUs and 250 GB of storage. (or as per your need)
Click "Apply" to save your selection.
SQL Database form is now complete; click "Create" to provision your database.
In the toolbar, click "Notifications" to see the deployment progress.

Create Server level Firewall rule

Once the deployment finishes, click "SQL databases" from menu.
Click the database created in the above process. E.g. sampleSQLDB.
Click "Set server firewall".

Click "Add client IP" to add your current IP address to new firewall rule. The firewall rule will open port 1433 to a single IP address or range of IP addresses.
Click "Save".