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’.
Step 3. Select Azure SQL and Click Create.
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:
Step 6. In Security, select the required settings and click Next:
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.
Wait for deployment to complete. Go to the resource, the newly created Azure SQL database will be shown below:
Now, select geeksqldb, and log in to Query Editor to add data to the database:
Example: Create a table in Azure SQL Database: