The Azure SQL PaaS service has quite a big variety of service tiers and according configurations. This snippet provides the cheapest configuration which can be seriously used for productive applications. This configuration serves low usage / performance requirements, but can easily be scaled to mid-range use cases. It also includes the network configuration to allow access for all Azure services (e.g. App Service or Synapse).
Further information to service models / tiers:
- MSDN Choose between the vCore and DTU purchasing models
- Purchase model
vCore: Allows cost-savings with Hybrid Benefit and Reserved Instances, but is generally rather expensive- Tier
Provisioned: Several sizes available - Tier
Serverless: Caution when allowing down-scaling to zero instances (long latencies possible)
- Tier
- Purchase model
DTU: Very difficult to pre-estimate the required size, but generally very cost-efficient - Scale up/down: Except for the serverless tier (vCore purchase model), there is no easy configurable auto-scaling available, only a manual scaling by adjusting the size (no to minimal downtime). This can be automated with e.g. an Automation Account script
