How should Azure SQL Database be designed for production in Microsoft Azure?

Use appropriate service tiers, resilient client connections, Entra authentication where possible, auditing, Defender, query monitoring, backup retention, and geo-replication when required.