Automating things using bicep for Azure deployment can be hard.<\/p>\n
While it is trivially easy to find<\/a> out how to configure maintenance windows for an SQL database using the Azure Portal directly, it is equally hard to find out how to set it using bicep deployment<\/p>\n No direct search gives any relevant links (apart from saying<\/a> the the <\/p>\n Finally found this<\/a>, leading to an AzCli (or Azure Powershell) command, that can list default public standard servicewindows.<\/p>\n So in \u201cWest Europe\u201d region, the standard Servicewindows are called: and the full string used for or alternatively<\/a><\/p>\n Automating things using bicep for Azure deployment can be hard. While it is trivially easy to find out how to configure maintenance windows for an SQL database using the Azure Portal directly, it is equally hard to find out how to set it using bicep deployment No direct search gives any relevant links (apart from … Continue reading “Azure Bicep Deployment – Maintenance Windows for sql-databases”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[30],"class_list":["post-1107","post","type-post","status-publish","format-standard","hentry","category-guides","tag-azure"],"_links":{"self":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/1107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1107"}],"version-history":[{"count":12,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/1107\/revisions"}],"predecessor-version":[{"id":1131,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/1107\/revisions\/1131"}],"wp:attachment":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}maintenanceConfigurationId<\/code> in the bicep-file must a \u201cstring\u201d)<\/p>\naz maintenance public-configuration list<\/code> gives a quite long list<\/p>\naz maintenance public-configuration list \u2013query \u201c[?location==\u2019westeurope\u2019]\u201d \u2013output table<\/code> is better.<\/p>\n
\n– SQL_Default
\n– SQL_WestEurope_DB_1 (Mon \u2013 Thu)
\n– SQL_WestEurope_DB_2 (Fri \u2013 Sun)<\/li>\nmaintenanceConfigurationId<\/code> would be \/subscriptions\/<<SUBSCRIPTION ID>>\/providers\/Microsoft.Maintenance\/publicMaintenanceConfigurations\/SQL_WestEurope_DB_2<\/code><\/p>\nsubscriptionResourceId(\u2018Microsoft.Maintenance\/publicMaintenanceConfigurations\u2019, \u2018SQL_Default\u2019)<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"