Azure Classroomnotes 10/Dec/2022

Azure SQL Database Continued

• Lets create a Azure sql database with sample data
• Elastic pool lets multiple databases share the same resources reducing costs.
  
• Lets create an azure sql db and post creation open the server firewall
  
  
• Once this is created lets add one more database to the elastic pool
  
  
• Note: Limits for Azure SQL Databases Refer Here
• Elastic Pool supports the following
  
• As discussed in the class where we were trying to resize the database sizes and still were able to use th database. This is referred as dynamic scaling.

Redundancy

• Azure Databases support 3 redundancy options
  • Locally Redundant Storage (LRS)
    • Store redundant copies of data with in same region across different racks
  • Zone Redundant storage (ZRS)
    • Store redundant copies of data with in same region across different zones
  • Geo-Redundant Storage (GRS)
    • Store redundant copies of data with in same region across different zones/racks and additional copies into other region.
• Next Steps:
  • Replication
  • Failovers.