Azure SQL Databases

• Azure SQL Database is fully managed Platform as a Service

• Create an Azure SQL Database

  • Pricing

    • DTU (Database Transaction Units)
    • vCore
      • Provisioned
      • Serverless

  • Connectivity

    • Private Endpoint:
    • Public Endpoint:
    • No Endpoint:

  • DataSource:

    • None: Create an Empty Database
    • Backup:
      1. Take the backup of your curent sql server & upload it to Azure to Some Storage Account
      2. Select that path to backup
    • Sample: Test Database called as AdventureWorks

  • Firewall:

    • Allow Azure Resources
    • Allow Specific IP Addresses

• Exercise: By the understanding which you get from above, try to create an Azure SQL Database which has public endpoint and sample database.

• Connecting with the Database using Query Editor

• Connecting with the Database using the SQL Server Mangement Studio, For Download Refer Here

• Now we have created a Database in Central US, What will happen if due to some disaster Central US is down, Can i have my database in other Region?

  • Yes, Azure Supports Geo Replication