Azure Classroom Series – 08/Sept/2020

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 Preview Preview Preview Preview Preview Preview Preview Preview Preview Preview Preview Preview Preview Preview

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

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

  • 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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About learningthoughtsadmin