Microsoft Azure – Configure Azure SQL

Pre-requisite: Azure VM

Azure SQL Database is a cloud-based PaaS database service that is completely managed and extremely scalable. When you need to establish a new application in the cloud, this service includes the essential database-level capabilities of an on-premises SQL Server. The Azure SQL Database can be used as a single database or as part of an elastic pool. Below are the steps to create an Azure SQL Database resource:

Step 1. Log in to Microsoft Azure Portal.

Step 2. Go to Search and type ‘Azure SQL’. 

Search Azure SQL

Step 3. Select Azure SQL and Click Create.

Creating SQL Resource

Step 4. In Basic, Select subscription, resource group (create new, if required), Database details including the database name, server name (create new if required), and database configuration (size, number of cores) Backup storage redundancy as shown below and Click Next:

 

Step 5. In Networking, Select Network connectivity, Firewall rules, Connection policy, Encrypted connections, and Click Next:

Network Configuration

Step 6. In Security, select the required settings and click Next:

Security Configuration

Step 7. In Additional Settings, Select data source (none for the blank new database, backup to restore from the older database, a sample will create AdventureWorksLT) and database collation, Click Next, add a tag if required, and Click Review + Create. 

Review of Configurations

Wait for deployment to complete. Go to the resource, the newly created Azure SQL database will be shown below:

Azure SQL created

 Now, select geeksqldb, and log in to Query Editor to add data to the database:

SQL query Editor

Example: Create a table in Azure SQL Database: 

Table created