Relational Database in Azure

• Azure offers the following databases as service
  • Microsoft SQL Server
  • Postgres
  • MySQL (mariadb)
  • Oracle (**)

Microsoft SQL Server

• SQL Server is offered in 3 different ways
  • Azure Database for SQL:
    • This is latest SQL Server with SQL Server functionality offered by Azure
    • Azure SQL Database is not part of your vnet
    • Azure SQL Database will create server and database
    • Firewalls are around server to whitelist ip’s or ip ranges
    • For private connectivity with your virtual network we can create
      • private endpoint
      • service endpoint
    • Usecases:
      • For users who use only sql server database features
      • for all new/modern cloud based deployments with SQL server features from low to highest cost ranges
    • Advantages:
      • most of the administratives activities are automated or can be automated with single click
      • Automated Performance tuning can be enabled.
        
  • SQL Virtual Machine
    • This is like a SQL Server installed on-premises on a virtual machine
    • We can rdp or login into vm and configure the necessary stuff
  • SQL Managed Instances
    • This is SQL Server where you can extend but still managed.
    • SQL Managed instance will be created in vnet and gives which version of database server do you want to run
    • This is used for applications especially during migrations where your application is using older versions of SQL Server and had extended the functionality of SQL Server.

Azure SQL Database

• Refer Here for SQL Database quickstart
• Purchasing Models: We have two options
  • DTU Based Purchasing Model: We have 3 options
    • Basic
    • Standard
    • Premium
  • vCore Based Purchasing Model
    • General Purpose
    • HyperScale
    • Business Critical
• Replicas:
  • We can create replicas in any region
  • For basic databases the failover is manual
    
• Sync:
  • We can choose what databases/tables to sync
• Elastic Pool