Office 365 usage report APIs in preview

We’ll get to configuring and using the Office 365 Usage Reports based on the beta endpoint of the Microsoft Graph API.   First let’s quickly overview why this is important.  On October 1st, 2017 some of the API endpoints for the tried and true Reporting webservice https://msdn.microsoft.com/en-us/library/office/jj984325.aspx will be deprecated.   I’ve grown to depend on…


How to change Azure SQL DB LTR Recovery Service Vault ?

Received a comment saying ‘Can’t Change the server Recovery Service Vault’, took a breathe and start a new Lab on Azure Portal trying to find out how it can be changed, after a lot of tries unfortunately I realized that it can’t be done through the portal, so what is our best friend Solution ?……


REST API Sample for exporting a database

While working on an Azure SQL Database support case, I needed to provide a REST API sample for exporting a database. I struggled a bit to get it to work, as the syntax is not really intuitive and requires creating an Azure AD application. To save you from the same struggle, here is the sample…


How to make an App Setting or Connection String sticky

I wrote an article here which talk about how to make an app setting or connection string sticky to the slot.  You can make the settings stick using Azure PowerShell. Here are the Azure PowerShell cmdlets required to create an Azure App Service Web App: Login-AzureRmAccount Set-AzureRmContext Set-AzureWebsite (also have a look here at the…


Scripting: Send email using Powershell and System.Net.Mail API

You can send email using System.Net.Mail API & PowerShell scripting. It’s easy, faster!! Lets try… Why Powershell? PowerShell is the automation platform and scripting language for Windows and Windows Server that allows you to simplify the management of your systems. Unlike other text-based shells, PowerShell harnesses the power of the .NET Framework, providing rich objects…

4

PowerShell Saturday in Hannover: Das 1×1 der Automatisierung in Azure (Follow Up)

Letztes Wochenende fand am Samstag der erste PowerShell Saturday der PowerShell Usergroup Hannover statt. Glücklicherweise durfte ich dort neben vielen anderen tollen Referenten auch einen Vortrag halten. Dazu gibt es heute dann hier die Folien und Dateien, wobei die Folien wahrscheinlich  keine große Hilfe sein werden, da der Vortrag ja nur aus einer großen Demo…


Azure AD – Working across tenants using PowerShell

Working across various tenants programmatically in Azure AD could be relatively complex. Before even writing a script to do such operations, one must be very clear about a few concepts about Azure AD. Azure AD application and service principal. An Azure AD application is defined by its one and only application object which resides in…


Adding additional intellisense to VS Code when editing PowerShell scripts

Most people that I talk to about my experiences writing PowerShell scripts these days will know that Visual Studio Code is my absolute preference for editor these days. It’s a great tool with lots of little tricks to help you improve your productivity – and recently I came across another one to help when I work…

1

Nailing it: Making Sense of Vague PowerShell Errors

This post on troubleshooting PowerShell errors comes to us from Premier Developer consultant Rob Vettor. PowerShell is a “must-know” for Azure cloud development. Yes, it’s a scripting language, but moreover, it’s an automation engine that can execute complex tasks with minimal effort. The vast majority of Azure administrative functionality is available in PowerShell. Many of…