Pause Idle Azure SQL Data Warehouse Instances

Azure SQL Data Warehouse (SQL DW) instances are quite expensive to keep running, so it makes sense to Pause them if they are not being used. This script will NOT resume them if connection attempts are made to a paused SQL DW instance. The easiest way to check if it has been awhile since the…


Resize Azure VMs in bulk

If you need to do a bulk update of VM sizes from one type to another to take advantage of new technology being released, this script should help you out. This script will work for Resource Manager VMs, and NOT Classic VMs. It targets VMs that are deallocated or have failed deployments only. VMs in…


Azure VMs – Active Directory members and getting time sync (ntp) right

I’ve recently had this question asked of me multiple times recently. “If a VM in Azure is a member of a Domain, where does it get its time from, Azure ( or the NTP source set by AD?” The answer is both, unless you make some changes. Here are the specific time setting recomendations, buried…


Using OMS and Runbooks to update VMs when they’re down

The aim of this post is to enable a powershell Azure Automation runbook to be fired when a VM is deallocated (Stopped from the Azure management fabric), that will perform given tasks. This is useful if you have non-urgent infrastructural changes that need to be done, but you want it done with the least amount…


Make practical use of NSG Flow Logs for troubleshooting

So, you’ve found the new Azure Network Watcher features. Cool, now I can start getting some real information about what’s going on in my Azure Network. The NSG flow logs section of the Network Watcher blade, in the Azure Portal, lets you specify a Storage Account for each NSG (Network Security Group) to output detailed…


Get Azure PaaS Endpoint IPs

I’ve had a few situations where people are trying to find out the public IP Addresses for their own resources in Azure to use for Network Security Groups or User Defined Routes. Unfortunately there is nothing generic out there that can return this information for every Resource Type, so specific code needs to be developed…


Log results from Azure Automation Runbooks directly to OMS

An easy way to keep track of Azure Automation runbook operations is to create log entries to OMS during execution. There is a Rest API service as part of OMS that let’s you post log entries directly into your OMS Workspace, allowing for easy searching and alerting of anything you’re runbooks do.  There are…


Transition Azure Automation schedules from one Runbook to another

So you’ve spent a great deal of time setting up all the schedules for an Azure Automation Runbook but now you have a new version that you want to test against all the parameters for the schedules of the existing released version. You’ve already created and published the new Runbook but what a pain if…


Export Available Azure VM Sizes for all locations

I wanted to share a quick post with a script I seem to use all the time to get a spreadsheet with all the available VM sizes available for use in each region Grab it from here –> Download script


Using Azure Automation and SharePoint Online lists to schedule VM start-up and shutdown

To make the most efficient use of Public cloud you need to ensure your servers are only running when they need to be. Using SharePoint online as the source of virtual machine start-up and shutdown schedules is an option that allows for an easy, consolidated view of all your VMs and their schedules plus allows…