{"id":1020,"date":"2017-02-08T18:19:46","date_gmt":"2017-02-08T16:19:46","guid":{"rendered":"http:\/\/whiteducksoftware.com\/?p=1020"},"modified":"2024-03-13T11:50:33","modified_gmt":"2024-03-13T10:50:33","slug":"azure-devops-scripts-auf-github","status":"publish","type":"post","link":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/","title":{"rendered":"Azure DevOps-Scripts auf GitHub"},"content":{"rendered":"

Azure DevOps-Scripts auf GitHub<\/h2>\n

Die Automatisierte Bereitstellung von Cloud Umgebungen und Prozessen ist f\u00fcr den produktiven Betrieb von Cloud-L\u00f6sungen unabdingbar. Denn je h\u00f6her der Automatisierungsgrad einer Cloud-L\u00f6sung ist, desto rentabler l\u00e4sst sich diese betreiben. White duck arbeitet in seinen Cloud Projekten genau in diesem Bereich intensiv mit seinen Kunden zusammen. Auf GitHub stellt white duck absofort diverse DevOps-Scripts und Tools f\u00fcr die Microsoft Azure Cloud bereit um dieses KnowHow in der noch jungen Cloud-Community zu teilen.<\/p>\n

\"\"<\/p>\n

<\/h1>\n

Archivierung von Azure SQL Database als BACPAC-Datei in Azure Blob-Storage<\/h1>\n

Mit dem neuen Feature “Long-term retention backup” (https:\/\/docs.microsoft.com\/de-de\/azure\/sql-database\/sql-database-long-term-retention<\/a>) von SQL Azure Database lassen sich Sicherungen bis zu 10 Jahre lang in einem Azure Recovery Service-Tresor aufbewahren. Jedoch ist es derzeit nicht m\u00f6glich Zugriff auf die SQL-Datenbank-Sicherungsdateien zu erhalten um diese beispielsweise auf einem OnPremise SQL Server wiederherzustellen. Abhilfe schafft das white duck Azure Automation \u201eBackup-SqlDatabase\u201c PowerShell Skript, welches Datenbanksicherungen als Bacpac-Datei in einem Azure Blob Storage ablegt.<\/p>\n

Git Repository: https:\/\/github.com\/whiteducksoftware\/azure-backupsqldatabase<\/a><\/p>\n

Berechtigungspr\u00fcfung einer Applikation \u00fcber die Azure AD Graph API<\/h1>\n

Mit dem PowerShell Modul white duck Azure Graph Explorer kann im Security-Kontext einer Applikation (Service Principal) die Azure Active Directory Graph API genutzt werden. Das Modul \u00fcbernimmt die Authentifizierung als Applikation und erm\u00f6glicht das Abfragen von Azure Active Directory Ressourcen. Das Microsoft Online Tool Graph Explorer\u00a0unterst\u00fctzt dies derzeit nicht, es ist lediglich eine Anmeldung als Benutzer m\u00f6glich. Die allgemeine Invoke-GraphRequest Methode bietet au\u00dferdem direkten Zugriff auf die API um Azure AD Ressourcen auch anlegen, \u00e4ndern oder l\u00f6schen (CRUD) zu k\u00f6nnen.<\/p>\n

Git Repository: https:\/\/github.com\/whiteducksoftware\/azure-graphexplorer<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Azure DevOps-Scripts auf GitHub Die Automatisierte Bereitstellung von Cloud Umgebungen und Prozessen ist f\u00fcr den produktiven Betrieb von Cloud-L\u00f6sungen unabdingbar. Denn je h\u00f6her der Automatisierungsgrad einer Cloud-L\u00f6sung ist, desto rentabler l\u00e4sst sich diese betreiben. White duck arbeitet in seinen Cloud Projekten genau in diesem Bereich intensiv mit seinen Kunden zusammen. Auf GitHub stellt white duck <\/p>\n

[…]<\/div>\n

<\/a><\/p>\n","protected":false},"author":3,"featured_media":2875,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_tribe_events_control_status":"","_tribe_events_control_status_canceled_reason":"","_tribe_events_control_status_postponed_reason":"","_tribe_events_control_online":"","_tribe_events_control_online_url":"","footnotes":""},"categories":[],"tags":[112,113,114,115,110,117,118,119],"class_list":["post-1020","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","tag-automation","tag-azure","tag-azure-ad","tag-bacpac","tag-devops","tag-github","tag-graph-api","tag-sql-database"],"yoast_head":"\nAzure DevOps-Scripts auf GitHub - white duck<\/title>\n<meta name=\"description\" content=\"Auf GitHub stellt white duck diverse DevOps-Scripts und Tools f\u00fcr die Microsoft Azure Cloud bereit, um dieses Knowhow in der noch jungen Cloud-Community zu teilen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure DevOps-Scripts auf GitHub - white duck\" \/>\n<meta property=\"og:description\" content=\"Auf GitHub stellt white duck diverse DevOps-Scripts und Tools f\u00fcr die Microsoft Azure Cloud bereit, um dieses Knowhow in der noch jungen Cloud-Community zu teilen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/\" \/>\n<meta property=\"og:site_name\" content=\"white duck\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/whiteduckgmbh\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-08T16:19:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-13T10:50:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/whiteduck.de\/wp-content\/uploads\/code-944499_1280.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"688\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Markus Suemmchen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@whiteduck_gmbh\" \/>\n<meta name=\"twitter:site\" content=\"@whiteduck_gmbh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Markus Suemmchen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/\"},\"author\":{\"name\":\"Markus Suemmchen\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/7b00817228fc904e115ab1c0c68a335a\"},\"headline\":\"Azure DevOps-Scripts auf GitHub\",\"datePublished\":\"2017-02-08T16:19:46+00:00\",\"dateModified\":\"2024-03-13T10:50:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/\"},\"wordCount\":281,\"image\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/code-944499_1280.jpg\",\"keywords\":[\"Automation\",\"Azure\",\"Azure AD\",\"BACPAC\",\"DevOps\",\"GitHub\",\"Graph API\",\"SQL Database\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/\",\"name\":\"Azure DevOps-Scripts auf GitHub - white duck\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/code-944499_1280.jpg\",\"datePublished\":\"2017-02-08T16:19:46+00:00\",\"dateModified\":\"2024-03-13T10:50:33+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/7b00817228fc904e115ab1c0c68a335a\"},\"description\":\"Auf GitHub stellt white duck diverse DevOps-Scripts und Tools f\u00fcr die Microsoft Azure Cloud bereit, um dieses Knowhow in der noch jungen Cloud-Community zu teilen.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/#primaryimage\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/code-944499_1280.jpg\",\"contentUrl\":\"https:\\\/\\\/whiteduck.de\\\/wp-content\\\/uploads\\\/code-944499_1280.jpg\",\"width\":1280,\"height\":688},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/azure-devops-scripts-auf-github\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure DevOps-Scripts auf GitHub\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/\",\"name\":\"white duck\",\"description\":\"Your Partner for Microsoft Azure & AI\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/#\\\/schema\\\/person\\\/7b00817228fc904e115ab1c0c68a335a\",\"name\":\"Markus Suemmchen\",\"sameAs\":[\"https:\\\/\\\/whiteduck.de\"],\"url\":\"https:\\\/\\\/whiteduck.de\\\/en\\\/author\\\/markus-suemmchen\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Azure DevOps-Scripts auf GitHub - white duck","description":"Auf GitHub stellt white duck diverse DevOps-Scripts und Tools f\u00fcr die Microsoft Azure Cloud bereit, um dieses Knowhow in der noch jungen Cloud-Community zu teilen.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/","og_locale":"en_US","og_type":"article","og_title":"Azure DevOps-Scripts auf GitHub - white duck","og_description":"Auf GitHub stellt white duck diverse DevOps-Scripts und Tools f\u00fcr die Microsoft Azure Cloud bereit, um dieses Knowhow in der noch jungen Cloud-Community zu teilen.","og_url":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/","og_site_name":"white duck","article_publisher":"https:\/\/www.facebook.com\/whiteduckgmbh","article_published_time":"2017-02-08T16:19:46+00:00","article_modified_time":"2024-03-13T10:50:33+00:00","og_image":[{"width":1280,"height":688,"url":"https:\/\/whiteduck.de\/wp-content\/uploads\/code-944499_1280.jpg","type":"image\/jpeg"}],"author":"Markus Suemmchen","twitter_card":"summary_large_image","twitter_creator":"@whiteduck_gmbh","twitter_site":"@whiteduck_gmbh","twitter_misc":{"Written by":"Markus Suemmchen","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/#article","isPartOf":{"@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/"},"author":{"name":"Markus Suemmchen","@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/7b00817228fc904e115ab1c0c68a335a"},"headline":"Azure DevOps-Scripts auf GitHub","datePublished":"2017-02-08T16:19:46+00:00","dateModified":"2024-03-13T10:50:33+00:00","mainEntityOfPage":{"@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/"},"wordCount":281,"image":{"@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/#primaryimage"},"thumbnailUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/code-944499_1280.jpg","keywords":["Automation","Azure","Azure AD","BACPAC","DevOps","GitHub","Graph API","SQL Database"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/","url":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/","name":"Azure DevOps-Scripts auf GitHub - white duck","isPartOf":{"@id":"https:\/\/whiteduck.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/#primaryimage"},"image":{"@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/#primaryimage"},"thumbnailUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/code-944499_1280.jpg","datePublished":"2017-02-08T16:19:46+00:00","dateModified":"2024-03-13T10:50:33+00:00","author":{"@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/7b00817228fc904e115ab1c0c68a335a"},"description":"Auf GitHub stellt white duck diverse DevOps-Scripts und Tools f\u00fcr die Microsoft Azure Cloud bereit, um dieses Knowhow in der noch jungen Cloud-Community zu teilen.","breadcrumb":{"@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/#primaryimage","url":"https:\/\/whiteduck.de\/wp-content\/uploads\/code-944499_1280.jpg","contentUrl":"https:\/\/whiteduck.de\/wp-content\/uploads\/code-944499_1280.jpg","width":1280,"height":688},{"@type":"BreadcrumbList","@id":"https:\/\/whiteduck.de\/en\/azure-devops-scripts-auf-github\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/whiteduck.de\/en\/"},{"@type":"ListItem","position":2,"name":"Azure DevOps-Scripts auf GitHub"}]},{"@type":"WebSite","@id":"https:\/\/whiteduck.de\/en\/#website","url":"https:\/\/whiteduck.de\/en\/","name":"white duck","description":"Your Partner for Microsoft Azure & AI","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/whiteduck.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/whiteduck.de\/en\/#\/schema\/person\/7b00817228fc904e115ab1c0c68a335a","name":"Markus Suemmchen","sameAs":["https:\/\/whiteduck.de"],"url":"https:\/\/whiteduck.de\/en\/author\/markus-suemmchen\/"}]}},"_links":{"self":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts\/1020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/comments?post=1020"}],"version-history":[{"count":0,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/posts\/1020\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/media\/2875"}],"wp:attachment":[{"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/media?parent=1020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/categories?post=1020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/whiteduck.de\/en\/wp-json\/wp\/v2\/tags?post=1020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}