Database Services in Azure

• Typical activities involved in creating a Database

  • Create an physical/virtual machine
  • Install the Database Software
  • Import the Data (Optional)

• Activities on the Created Database

  • Back up of the database
  • Replications of the database
  • Performance Tuning
  • User Management
  • Applications/user accessing the data for CRUD

• Possibilities in Azure are

  • Create an Azure VM and perform all of the above activities (Un-managed)
  • Azure Gives Managed Databases where
    • Creating a Database is managed by Azure
    • Backups & Replications will be done Azure you have to configure when and where
    • For Microsoft SQL Performance Tuning can be automated
    • Azure Supports integrated Azure AD Authentication to Databases

• In the Relational Databases, Azure supports Managed options for

  • Microsoft SQL Server
  • mySQL
  • PostgreSql

Azure SQL

• Is family of managed SQL Server database engine in Azure Cloud

• Let’s create one Azure SQL Database

• Navigate to Home => All Services => Select Databases

• Navigate to Home => All Services => Marketplace and search for oracle

• Azure SQL is offered using

  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server on Azure VMs

Azure SQL Database

• Database as a service offering from Azure.
• This also offers serverless compute.
• This is Platform as a Service offering of Microsoft SQL Server
• The following deployment options are provided
  • A single database
  • An elastic pool