Azure SQL Database Types, Costs and Use Cases Azure Masterclass

Relates to Azure SQL Cloud Engineering Devops and comparison of SQL types

0:00 Intro

Cost considerations Technical differences Use cases

0:58 Overview of SQL Products in Azure

Transact-SQL, MySQL, NoSQL, PostgreSQL, MQL, CQL

1:37 Azure SQL Database Overview

• Scalable
• High Available
• Seamless integration

1:51 SQL Managed Instance Overview

• Broad SQL server compatibility
• Easy to “lift-and-optimise” from existing on-prem SQL
• Backups
• High availability It is SQL as a service

2:18 SQL Server on Azure VM Overview

• Traditional Windows Server with MS-SQL installed
• Least Azure features
• More management overhead
• Most compatibility with traditional SQL Server features

2:52 Azure SQL Database Pricing

• DTU based
  • original option, simplest
  • compute, storage, iops is DTU
  • great for infrastructure team
• VCore based
  • introduced more recently
  • flexibility
  • independently scale storage
  • good for db admins
• Dynamic scaling

3:53 Azure Managed Instance Pricing

• VCore
  • Have a virtual machine starting from 800$ per month
  • You choosee CPU, VCore, performance
    • Business Critical
      • High performance, high availability
    • General purpose
      • cost effective

4:28 SQL Server on Azure VM Pricing

• SQL Server licencing is on you