Azure Classroom notes 24/Jan/2024

Microsoft SQL Server on Azure

• Azure gives 3 options
  • Azure SQL Database:
    • This is SQL Database as a service
    • This has database offerings with no extra SQL Server features
    • Azure SQL Database can be connected
      • from vm using internet or private endpoint
      • To other azure services we need to explicitly allow access to azure services.
    • Connectivity:
      
    • Compute and Size:
      
  • SQL Managed Instances
    • This is SQL Server Managed instance
    • This is equivalent to SQL Server Enterprise versions
    • Connectivity:
      
  • SQL on VMs:
    • This is SQL server pre-installed on VM with additional automation features
    • Connectivity: Since this is vm it will be in your virtual network