Skip to content
Related Articles
Get the best out of our app
GeeksforGeeks App
Open App

Related Articles

Microsoft Azure – Configure Azure SQL

Improve Article
Save Article
Like Article
Improve Article
Save Article
Like Article

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’. 

azure sql

Search Azure SQL

Step 3. Select Azure SQL and Click Create.

sql deployment

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:

create db


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

network config

Network Configuration

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

security config

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:

login sql

SQL query Editor

Example: Create a table in Azure SQL Database: 

query editor

Table created

My Personal Notes arrow_drop_up
Last Updated : 30 Mar, 2023
Like Article
Save Article
Similar Reads
Related Tutorials