Day 30: Create Azure SQL Database

☁️ Day 30: Create Azure SQL Database | 100 Days of Cloud (Azure) Welcome to Day 30 of the 100 Days of Cloud (Azure) series! In this lab, you’ll create a publicly accessible Azure SQL Database along with its SQL Server configuration — an important step in building cloud-hosted database infrastructure. 📌 Lab Objective: Create and configure an Azure SQL Database with the required compute, storage, backup, and networking settings. 🛠️ Task Requirements: Database Name: nautilus-sqldb Server Name: nautilus-server-30324 Region: southcentralus Compute Tier: Basic Backup Storage Redundancy: Locally-redundant Database Size: 2 GiB Admin Username: nautilus-admin Publicly accessible database 💻 Using Azure Portal: 🔹 Log in to Azure Portal 🔹 Go to SQL databases 🔹 Click Create 🔹 Create a new SQL Server: Server Name: nautilus-server-30324 Region: South Central US Authentication: SQL Authentication Admin Username: nautilus-admin Set secure password 🔹 Configure Database: Database Name: nautilus-sqldb Workload: Development / Basic Compute + Storage: Basic Max Size: 2 GiB 🔹 Backup Storage: Set redundancy to: Locally-redundant backup storage 🔹 Networking: Enable public access Allow Azure services and resources to access this server 🔹 Review and Create 💻 Useful Azure CLI Commands: 🔹 1. Create SQL Server az sql server create \ --name nautilus-server-30324 \ --resource-group RESOURCE_GROUP_NAME \ --location southcentralus \ --admin-user nautilus-admin \ --admin-password YOUR_PASSWORD 🔹 2. Create SQL Database az sql db create \ --resource-group RESOURCE_GROUP_NAME \ --server nautilus-server-30324 \ --name nautilus-sqldb \ --service-objective Basic \ --max-size 2GB 🔹 3. Configure Firewall Rule for Public Access az sql server firewall-rule create \ --resource-group RESOURCE_GROUP_NAME \ --server nautilus-server-30324 \ --name AllowAllAzureIPs \ --start-ip-address 0.0.0.0 \ --end-ip-address 0.0.0.0 🔹 4. Verify Database Status az sql db show \ --resource-group RESOURCE_GROUP_NAME \ --server nautilus-server-30324 \ --name nautilus-sqldb \ --query status ✅ Expected output: Online 📚 What You’ll Learn: Azure SQL Database deployment SQL Server configuration in Azure Public database accessibility setup Backup redundancy concepts Azure database sizing and compute tiers Cloud database administration basics 🌟 Why This Lab Matters: Managed cloud databases are a core part of modern cloud infrastructure. Understanding Azure SQL setup and configuration is essential for cloud engineers, DevOps engineers, and database administrators. 🎯 Series: 100 Days of Cloud (Azure) Build real-world Azure infrastructure skills step by step. 🔔 Follow OtterTech for more Azure, AWS, Kubernetes, Linux, Docker, and DevOps tutorials! #Azure #AzureSQL #SQLDatabase #CloudComputing #DatabaseAdministration #AzureCLI #CloudDatabase #100DaysOfCloud #OtterTech #Day30