What is Azure SQL?

• SQL Database services built upon SQL Server engine in the Azure cloud
• Azure SQL is a family of fully managed, secure and intelligent SQL database services, built upon the same SQL Server engine
• It offers a wide range of deployment options and control requirements application patterns to meet the most demanding migration and modernisation initiatives

Azure SQL database services

SQL Server Database Engine products in Azure cloud:

• Azure SQL Managed Instance (PaaS)
• SQL Server on Azure VM (IaaS)
• Azure SQL Database
  • a fully managed platform as a service database engine
  • deployment options: Single database & Elastic pool
• Azure SQL Edge: Small-footprint, edge-optimised SQL database engine with built-in AI

Choosing which one to use

• https://azure.microsoft.com/en-gb/services/azure-sql/#choose-your-database
• Choosing The Right Azure SQL Service for You
• IaaS or PaaS Managed Instance, Azure DB or Azure VM Why, when, what

Templates in Azure Marketplace

• Multiple templates are available in Azure portal for provisiong SQL Server Database
• Microsoft consolidated all options into a single template “Azure SQL”
  • Portal > Create resource > Search “SQL”
  • Use “Azure SQL” template
  • Direct link: https://portal.azure.com/#create/Microsoft.AzureSQL
• When using “Azure SQL” template, you will be presented with 3 deployment options
  • Azure SQL Databases
    • Single Database
    • Elastic pool
    • Database Server
  • Azure SQL Managed Instance
  • SQL virtual machines

Usage

• Save with the lowest total cost of ownership
• Migrate your SQL workloads with SQL Server on Azure Virtual Machines.
• Modernise your existing applications with Azure SQL Managed Instance.
• Support modern cloud applications with Azure SQL Database.
• Use your existing SQL skills in the cloud on the same SQL Server engine.
• Keep making the most of your current licence investments.