PowerShell

Query Azure SQL Database using Service Principal with PowerShell

by

Looking to query Azure SQL SQL Database using Service Principal with PowerShell? Have a look at this blog post! Recently I had been asked to configure a script that can be used to query an Azure SQL Database table data using a service principal with PowerShell; in this blog post I am going to show … Read more

Configuring Always On device based VPN using Azure VPN Gateway

by

What is Always On VPN? Always On VPN is the recommended replacement for Microsoft’s DirectAccess, it is also a Microsoft Product that allows you have a constant VPN connection to a selected network. In this blog, I am going to show you how you can use an Always On device based VPN setup utilising an … Read more

Creating Azure Activity Log Alerts with PowerShell

by

Want to create alerts from the Azure Activity Log? I will be showing how to do this with the PowerShell cmdlet Set-AzActivityLogAlert using conditions taken from a json output of the Activity Log. For the example I will be looking at alerting when a change has been made to a Network Security Group (NSG) I … Read more

Azure Dashboards

by

Centralise your queried data graphs/charts etc with Azure Dashboards – such a powerful resource within Microsoft Azure! A fully customisable user interface within a dashboard type environment, this should be configured for a “first-stop” for your team(s) to keep an eye on:- metrics, graphs and data within these dashboards. Why Azure Dashboards? Simple to create … Read more

Azure Functions:– Using PowerShell to automatically Tweet a random Blog Post from Table Storage

by

I have now got 30+ Blog posts, all of which I would want to share via Twitter on a repetitive basis, say for example 3 times a week. Yes, I could use TweetDeck or potentially another third-party tool but this is manual configuration as to what Tweet to send and when, I just want to … Read more