Testing Professor
Testing ProfessorMulti-Cloud Guidebook · Azure
All Azure services

Azure · Database

Azure SQL Database

Managed SQL Server with auto-tuning.

Official docs

Overview

Fully managed SQL Server engine with serverless tier, geo-replication and PITR.

When to use it

  • OLTP
  • Migrated SQL Server workloads
  • Test fixtures with PITR

Setup

  1. Create logical server + DB.
  2. Configure firewall + AAD admin.
  3. Add private endpoint for VNet access.

How to use

Copy DB for tests
az sql db copy -g qa-rg -s prod-sql -n prod --dest-name prod-copy-pr42 --dest-server qa-sql

QA use cases

  • Clone prod-like snapshot for performance test runs.