Azure Classroom Series – 18/Nov/2021

Azure SQL Databases Contd..

• Azure SQL Database is fully managed database engine that handles most of the database management functions such as upgrading, patching, backups & monitoring without user involvement.
• Azure SQL Database always runs on the latest stable release of SQL Server database.
• Deployment models
  • Single Database: represents a fully managed isolated database, you might use this option for modern cloud applicatins & microservices that need as single reliable datasource
  • Elastic Pool: Represents collection of single databases with a shared set of resource such as CPU or memory. Single databases can be moved into and out of elastic pool
• Purchasing Models:
  • vCore-based purchasing model:
    • This model lets you choose the number of vCore, the amount of memory & speed of storage.
    • The vCore-based purchasing model also allows you to use Azure Hybrid Benifit for SQL Server to gain cost savings.
    • This is recommended model by Microsoft Azure
  • DTU-based purchasing model:
    • Database Transaction Unit offers a blend of compute, memory and I/O resource which supports light ot heavy database workloads
  • Serverless model:
    • This model automatically scales compute based on workload demand & bills for the amount compute per second.
    • The serverless compute tier also automatically pauses the database during inactive periods when only storage is billed and automatically resumes databases when activity returns
• Service Tiers: Azure SQL Database offers three service tiers that are designed for different types of application workloads
  • General Purpose/Standard:
    • Designed for common workloads
    • offers budget oriented balanced compute and storage options
  • Business Critical/Premium
    • Designed for OLTP applications with high tranasaction rate & lowest latency I/O
    • This offers highest resilience to failures by using several isolated replicas
  • HyperScale
    • Designed for very large OLTP database & ability to autoscale storage and scale compute fluidly
• Activity:
  • Create a Azure SQL Database
    • Service Tier: General Purpose
    • Purchasing Model: Serverless
    • Deployment Model: Single Databases
    • Network Public Endpoint
    • Allow Azure Services & Allow Current IP Option
    • Ensure Sample Datbase is selected.
• Connectivity:
  • Generally databases will be connected from applications
  • Client Softwares to connect to database depending of Database Engine
    • SQL Server => SQL Server Management Studio
    • Postgres => PgAdmin
    • mySQL => mysql workbench