I periodically review Azure PaaS resource edge security. As a part of that process I examine and cleanup AzureSQL firewall rules. Once you have more than a handful of subscriptions and AzureSQL databases, doing this manually starts becoming unfeasible. To that end, Azure Powershell is your friend… As is typical, you need to install the […]

When your business hinges upon remote workers and remote offices, secure connections, and lots of data manipulation… how do you deal with some of your folks being extra remote? Granted the internet in 2020 is very different from the internet in say 2008 and the world has grown ever smaller as a result… but distance […]

The current state of the world has caused some unique stresses on IT infrastructure. For IT departments servicing internal teams, remote access infrastructure in particular has felt the brunt of the blow. To that end, I spent a couple of weeks testing out enterprise VPN solutions.

Continuing on my journey up the Azure Automation mountain, I recently completed a simple AZ PowerShell script that takes several input parameters and scales UP or scales DOWN a given AzureSQL database instance depending on what time of day it is. Before I go any further, if you are just getting started in Azure Automation, […]

I have been using Powershell to manage pieces of Azure on and off for about a year and half now. I had heard tell of Azure Automation but never really had a good reason to justify spending the time climbing that particular mountain (hill really…). Then the request came through… let’s scale AzureSQL databases up […]

I recently ran into a frustrating issue where I setup a new subscription in Azure and when I went to manage with Powershell I couldn’t see on the list that gets output from the following command: Get-AzSubscription

A colleague of mine recently solved one of the biggest pain points I have dealt with regarding Office365 – that is, Microsoft’s seemingly hit-or-miss modern authentication. Symptoms look like this: 1. Outlook client can’t connect and/or authenticate for end-users 2. Turning on Azure MFA for an end-user ruins their life (and yours) because all office […]

FIRST – I am stealing code here and re-sharing (with very little modification). All credit goes the fine gentleman that wrote these two articles, I would urge you to read them: Bulk Add IP Access Restrictions to Azure App Service Using AZ Powershell Bulk Add Cloudflares IPs to Azure App Service Access Restrictions Using AZ […]

This will (hopefully) be brief… Here is the Scenario: You have deployed Office365 You have an on-prem Domain Controller (hopefully more than one!) You are using Azure AD Connect 1.1 or greater, (which is installed on one of your domain controllers) You create or manage user accounts using your on-prem domain controllers Whenever you create […]

I had a recent requirement from one of our clients that took a little bit of tinkering to figure out… we will call our client Contoso LLC. and our project that we host for them we will call the “Cool Widget Project.” We built a really neat widget of an application for Contoso to use […]

This is redacted version of a powershell script I had to come up with recently to fix an issue with a web application in our environment. $hostsPath = "$env:windir\System32\drivers\etc\hosts" $ip = ipconfig | findstr /i IPv4 |Out-string $ip = $ip.TrimStart("IPv4 Address. . . . . . . . . . . : ") $ip = […]

I had some trouble finding some good examples of syntax and full explanation for creating VHD files (attaching new hard drives) from the Azure Powershell command line and attaching them to existing VMs. Here is my quick and dirty method of doing just that…