Azure Classroom Series – 06/Jan/2021



Offering of SQL Database from Azure

  • IAAS: Using Azure VMs and building SQL on them
    • Scenarios that would fit building SQL on Azure VMs:
      • Migrating existing apps to Azure with minimal changes
      • Having a full access into Azure SQL Environment
      • Building hybrid cloud applications
  • PAAS: Azure SQL Database (SQL Server as a Service)
    • Scenarios that would fit Azure SQL Database:
      • Cloud applications that needs to be developed quickly
      • Building a highly available & auto-upgradabale database that is recoverable in the case of disasters
      • Database with less management need for its OS and configuration

Advantages of Azure SQL Database

  • Scalability
  • Online scaling: No downtime is needed to scale your database size
  • Built-in intelligence: This helps in reducing costs and increasing performance
  • Automatic Backups
  • Point-in-time restores
  • Failover groups
  • Active geo-replicate.

What Database Engines are natively covered under PAAS model

  • Microsoft SQL Server => Azure SQL Database
  • Postgres => Azure SQL for Postgres
  • mySQL => Azure SQL For mySQL Preview

How about other Databases

  • You can search them in Azure Marketplace and create vm’s with that Preview Preview Preview
  • Create a Azure VM and install any Database Engine

Endpoints of Azure SQL Database

  • Azure SQL Database has an option of private endpoint which helps in connecting to azure sql privately using an ip with network range Preview
  • Now lets see the options in azure portal Preview Preview Preview Preview
  • Next steps:
    • Lets create a virtual network
    • in that virtual network lets create a vm
    • Lets create azure sql and add private endpoint to the network
    • Lets explore public endpoints and no access options
      • SQL Firewall

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About learningthoughtsadmin