Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.
2.2. The Azure SQL Family: Choosing the Right Host
š” First Principle: The choice of database hosting involves a trade-off between Control (IaaS) and Convenience/Management (PaaS). More control means more responsibility.
Scenario: A company migrating to Azure has three SQL Server workloads: (1) A legacy app requiring SQL Server 2012 on Windows Server 2016 with specific OS-level configurations. (2) An enterprise ERP using SQL Agent for job scheduling. (3) A new cloud-native microservice needing a simple, scalable database.
Each workload maps to a different Azure SQL option.