This Azure SQL tutorial will discuss the quick steps to create an SQL database in Azure using Azure Portal and PowerShell. Apart from this, we will also discuss the below topics
How to create SQL database in Azure [Azure Portal]
Before starting the topic of How to create an Azure SQL database, you can check out the Azure SQL Database Tutorial for a better idea.
Well, it’s quite easy to create the Azure SQL database using the Azure Portal.
Follow the below steps to create a free SQL Database in Azure.
1. Log in to the Azure portal (https://portal.azure.com/)
2. Search for Azure SQL and select it.
3. Click on the Add button On the Azure SQL page.
4. On the Select SQL deployment option window, click the Create button from the SQL database option.
5. On the Basics, Fill the below details.
- Subscription: Select the correct subscription.
- Resource group: Create a new resource group by clicking on the Create new link.
- Database name: Provide a meaningful database name.
Server: Click on the Create new link to create a new server. Enter the below details on the New server form.
- Server name: Enter a unique server name
- Server admin login: Enter Azure user.
- Password: Enter a password and enter it again in the Confirm password field.
- Location: Choose a location here
Click on the OK button
6. Compute + storage: It will load a default one. if you want to reconfigure the defaults, select the Configure database link.
On the Configure page, you can choose the below details.
- You can change the Compute tier from Provisioned to Serverless.
- Change the settings for vCores and Data max size.
- Click on the Change Configuration button to change the hardware generation.
Now click on Apply.
7. Click the Next: Networking> button in the Networking tab.
In the Networking tab, Choose the below options
- Select the Connectivity method as a Public endpoint.
- Choose the No option for Allow Azure services and resources to access this server.
- Select the Yes option for Add current client IP address.
8. Click on the Next: Additional settings > button to go to the Additional settings page
- Select the Sample option to Use existing data
- Click on the Review + Create button.
9. Click the Create button to create the Azure SQL database.
Note: Do not forget to read the terms properly before clicking the Create button.