A comment on the Powershell to stop/start the triggers, there is a current bug in the module and so a workaround is documented in this issue:
 
https://github.com/Azure/azure-powershell/issues/16368#issuecomment-975110601
 
Here's a sample to get it working:
 
           Install-Module -Name "Az.Synapse" -Confirm:$false  -Scope CurrentUser  -Force;
           $bearerToken = Get-AzAccessToken -ResourceUrl https://dev.azuresynapse.net
           $authHeader = @{
             'Content-Type' = 'application/octet-stream'
             'Authorization' = 'Bearer ' + $bearerToken.Token
           }
           $triggersSynapse = Get-AzSynapseTrigger -WorkspaceName "$(synapseWorkspaceNameProd)"; 
           $triggersSynapse | ForEach-Object { Invoke-WebRequest -Method POST -Uri "https://$(synapseWorkspaceNameProd).dev.azuresynapse.net/triggers/$($_.name)/stop?api-version=2020-12-01" -Headers $authHeader}