This repository is to help provide guidance and scripts on how to bulk register SQL Server Virtual Machines in Azure with the Azure SQL IaaS Agent Extension in Azure Government. To see the registration in action you can view the video on registering your SQL VMs.
The .psm1 script in this repository is the same one used in the video, but comes pre modified:
- [x] Modified to work from Azure Cloud Shell
- [x] Modified to log into Azure Government
| Capability | Lightweight mode | Full Mode |
|---|---|---|
| HA/Distaster Recovery License Type Take advantage of HA/DR |
✔️ | ✔️ |
| Flexible Licensing Switch Between PAYGO and AHB |
✔️ | ✔️ |
| Unified Management View Managed your SQL VM/PaaS Deloyments from one location |
✔️ | ✔️ |
| Automated Backup Easy backup with Point-in-Time Restore |
❌ | ✔️ |
| Automated Patching Free, Simple installation of Critical Updates (2008 R2+) |
❌ | ✔️ |
| Disk Scaling Resize Data and Log disks from the Azure Portal |
❌ | ✔️ |
| Simplified Always On HA Create Availability Groups with Azure CLI (GUI in Preview as of Oct 2020) |
❌ | ✔️ |
| Azure Key Vault Ingegration Configure Azure Key Vault for the SQL Server instance |
❌ | ✔️ |
| Add'l Integration with Azure Tighter integration with Azure Defender, Vulnerability Assessment and Monitoring services |
CY21 | CY21 |