Azure Classroom Series – 19/Nov/2021

Elastic Pools

• Unpredicatable usage patterns can make it hard to manage costs and your business model, Elastic pools are designed to solve this problem.
• You allocate performace resources to a pool rather than individual database i.e. you pay for the collective performance of the resources rather than individual database
• Elastic Pools are present in DTU model and also in vCore based resource limits
  • Resource limits for elastic pools using the vCore purchasing model Refer Here
  • Resource limits for elastic pools using the DTU model Refer Here
• Single Database Resource Limits
  • V-core Refer Here
  • DTU Refer Here

Azure SQL Server

• When we create an SQL Database, a Logical SQL Server Gets created
• Resource Limits Refer Here

Activity

• Create an Azure SQL Database with
  • Basic DTU
  • 2GB Storage Size
  • Sample Data
  • Public Connectivity
• Resources Created are Azure SQL Database and Azure SQL Server
• A Server is a logical construct that acts as a central administrative point for collection of databases where you can administer
  • logins
  • firewall rules
  • auditing rules
  • Threat detection policies
  • Auto-failover groups
• Lets Navigate to this server
• Connecting to public database over SQL Server Management Studio
• Azure Data Studio:
  • Download Refer Here