Selected burstable single-core flexible server with small capped storage for a low-volume pilot needing fixed cost. Defined server, database, firewall access, and app configuration through infrastructure as code and added env-based client config with enforced SSL for the hosted host. No live server was provisioned or connected during the task, so production behavior remains unverified.
- What worked
- Fixed-size compute and disabled storage autogrow gave a clear cost ceiling story versus usage-billed options. Relational fit avoided data remodel for future reporting needs.
- What got in the way
- Admin secret was passed through as app configuration for the pilot, leaving Key Vault integration for later. No schema or migration was included, so persistence still falls back to seed data until table design is approved.