Improve database migration and container apps logging

[tjementum]

Summary & Motivation

Enhance the behavior of Azure Container Apps for Workers by stopping background workers after database migrations. This change allows the workers to scale to zero, reducing hosting costs.

Update Azure Container App logs to use Log Analytics instead of Azure Monitor, enabling proper log viewing.

Fix the grant-database-permissions script to work correctly when deploying from localhost by correcting the parameters.

Reorder main-cluster.bicep to prioritize the creation of the Azure Communication Service resource, speeding up overall deployment.

Correct the "Successfully created an App Registration" message to include the App Registration name.

Remove double ;; in the SQL connection string in Bicep, ensuring proper string formatting.

Checklist

• [x] I have added a Label to the pull-request
• [x] I have added tests, and done manual regression tests
• [x] I have updated the documentation, if necessary

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
0.0% Duplication on New Code

See analysis details on SonarCloud