| Platform/deploy · SQL offerings, Arc, Fabric, partitioning and deployment |
01 Relational Data and Azure SQL, 02 SQL Platform Selection and Migration |
| Platform/scale · Compute/storage sizing, compression and partitioning |
02 SQL Platform Selection and Migration, 04 Query Performance and Database Maintenance |
| Platform/migrate · Online/offline migration, compatibility and troubleshooting |
02 SQL Platform Selection and Migration |
| Security/identity · Entra/SQL principals and permissions |
03 SQL Security and Compliance Controls |
| Security/encryption · TDE, Always Encrypted, networking and object encryption |
03 SQL Security and Compliance Controls |
| Security/compliance · Audits, classification, masking, ledger and row security |
03 SQL Security and Compliance Controls |
| Performance/monitor · Baselines, watcher, Extended Events and metrics |
04 Query Performance and Database Maintenance |
| Performance/query · Query Store, DMVs, plans, blocking and indexes |
04 Query Performance and Database Maintenance |
| Performance/configuration · Maintenance, tuning, Resource Governor and scaling |
04 Query Performance and Database Maintenance |
| Automation · Agent, elastic jobs, deployment and task troubleshooting |
05 SQL Automation, Backup and High Availability |
| Recovery · Strategy, native backup/restore, retention and HA/DR implementation |
05 SQL Automation, Backup and High Availability |
