Azure SQL Deployment

IntermediateDatabases
Azure SQLAzure CLISSMS

Objective

Deploy and configure an Azure SQL Database from CLI and portal.

Tools & Technologies

  • Azure SQL
  • Azure CLI
  • SSMS

Key Commands

az sql server create --name myserver --resource-group rg1
az sql db create --resource-group rg1 --server myserver --name mydb
az sql server firewall-rule create --name AllowMyIP

Lab Steps

01
Provision Server

Create an Azure SQL logical server with admin credentials.

02
Create Database

Deploy a database with specified tier and compute.

03
Firewall Rules

Configure firewall rules to allow connection from your IP.

04
Connect & Query

Connect with SSMS or sqlcmd and run initial queries.

Challenges Encountered

  • Firewall rules take 1-2 minutes to propagate
  • DTU vs vCore pricing model differences

Key Takeaways

  • Azure SQL Managed Instance offers more SQL Server feature parity than SQL Database
  • Use connection strings from the portal — don't construct them manually