Azure SQL Database Quickstart

Open your web browser and navigate to the Azure portal. Sign in with your Azure account credentials.

In the Azure portal, search for "SQL databases" in the top search bar and select "SQL databases" from the results.

Alternatively, you can click the menu icon (☰) in the top-left corner, select "All services", and then search for "SQL databases" under the "Databases" category.

On the SQL databases page, click the + Create button.

On the "Create SQL database" page, you'll need to configure the following settings:

• Subscription: Select the Azure subscription you want to use.
• Resource group: Choose an existing resource group or create a new one. A resource group is a logical container for your Azure resources.
• Database name: Enter a unique name for your database (e.g., my-sql-db-quickstart).
• Server:
  • If you have an existing SQL server, select it from the dropdown.
  • If you need to create a new server, click Create new.
  • Server name: Choose a globally unique server name.
  • Location: Select the Azure region closest to you or your users.
  • Administrator login: Enter a username for the server administrator.
  • Password: Create a strong password and confirm it.
• Workload environment: Select "Production" or "Development".
• Compute + storage: Click Configure database.
• Service tier: For quickstarts, the "General Purpose" tier with a "Burstable" compute option is often cost-effective. You can choose a specific vCore or DTU based on your needs.
• Max data size: Set the maximum size for your database.

Navigate to the Networking tab. For initial testing, you can enable "Allow public Azure services and resources to access this server". You'll likely want to configure stricter firewall rules for production environments.

Go to the Review + create tab. Azure will validate your configuration.

Once validation passes, review the summary of your settings. If everything looks correct, click the Create button.

Azure will now provision your SQL database. This typically takes a few minutes. You can monitor the deployment progress in the Azure portal notifications or on the deployment page.

Once the deployment is complete, you will see a "Your deployment is complete" message.