Azure Classroom Series – 25/Apr/2020

Azure Relational Datbase Options for SQL Server

• AZURE SQL is Platform as a Service or Datbase as a Service
• Deployment Models for the Managed Azure SQL:

  • Azure SQL Database Single

    • Fully managed isolated database
    • Possible option for all the modern applications
    • Much like a contained databases Refer Here

  • Managed Instance

    • Fully managed instance of SQL Server
    • It contains set of of databases that can be used together
    • Migration from on-premise SQL Server to Azure cloud this is an easier option

  • Elastic Pool:

    • Collection of Single Databases with shared system resources like cpu & Memory

• Lets Explore Pricing over here
• Below are some of images with database options

Lets Create an Azure SQL Database from Portal

Exercises:

1. Play around with Azure Pricing Calculator to understand different options and price impacts
2. Create the database as shown above