5 ways to secure your SQL data in Microsoft Azure

Data security in the cloud is of chief concern not only to healthcare and financial services, but anyone with sensitive data of any kind that should only be disclosed to authorized parties. No discussion of enterprise security would be complete without a look at data protection and governance. For purposes of this discussion, data comes … Continue reading “5 ways to secure your SQL data in Microsoft Azure”

Remoting in Azure Automation Runbooks (SQL DB Creation sample)

I find that using PowerShell remoting in my Azure automation runbooks is sometimes more convenient, as it eliminates the need to install and update additional PowerShell modules on my OMS hybrid runbook worker. For future reference, I wanted to capture an example of a simple approach to PowerShell remoting I find intuitive. The activities in this … Continue reading “Remoting in Azure Automation Runbooks (SQL DB Creation sample)”

Searching files in a zip archive in memory with PowerShell

I found myself tonight needing to build a function to search the contents of text files in a very large zip archive to find one containing a specific value. To handle the operation quickly, I wanted to perform the operation in memory. While that may be too specific to be useful for most, I thought … Continue reading “Searching files in a zip archive in memory with PowerShell”

Creating (and deleting) checkpoints for multi-VM sets in Hyper-V

When writing custom PowerShell DSC, I am typically working with complex configurations that involve not only multiple software installs, but database creation and domain join, resulting in changes on multiple VMs. In order to rollback operations on a front-end server, back-end SQL and an AD domain controller, I need snapshots of all VMs at the … Continue reading “Creating (and deleting) checkpoints for multi-VM sets in Hyper-V”

3 Truths of Modern Enterprise Security

The threat landscape, specifically the types and sources of threats, has changed significantly in the last few years. There are a number of readily identifiable causal factors, including:  Changes in technology. The introduction of new technology results in weaknesses that are related to low technological maturity, improper use, improper integration with existing systems, low user … Continue reading “3 Truths of Modern Enterprise Security”

Azure Automation Runbook to Add Computer to ConfigMgr Collection

Below for reference a quick PowerShell sample for adding a computer to a device collection in System Center Configuration Manager (ConfigMgr) via Azure Automation runook, designed for use on an OMS Hybrid Runbook Worker. It uses WMI, and so does not require the ConfigMgr PowerShell cmdlets. This also means it works for ConfigMgr 2012 and 2016. … Continue reading “Azure Automation Runbook to Add Computer to ConfigMgr Collection”

Switch from dynamic IP to IP Pool in VMM 2016

Recently I migrated a VM from standalone Hyper-V server in 2016 to a Hyper-V cluster managed by Virtual Machine Manager (VMM) 2016. The VM was using DHCP for addressing and I wanted to flip it to get its address from the IP pool assigned to its logical network in VMM. However, even with the VM … Continue reading “Switch from dynamic IP to IP Pool in VMM 2016”

TIP: Keep your Azure Automation runbooks healthy across PowerShell module updates

Here’s a quick tip that may help you ensure you’re protect yourself from a problem that happens occasionally. Problem: I had a runbook that was broken when the PowerShell modules in the store were updated. Solution: What can you do to prevent this problem? One thing you can do to protect yourself against breaking changes in … Continue reading “TIP: Keep your Azure Automation runbooks healthy across PowerShell module updates”

Creating ConfigMgr Console Folders and Collections with PowerShell

Below for reference a quick PowerShell sample for creating a query-based device collection in System Center Configuration Manager (ConfigMgr), as well as a new folder for organizing collections in the ConfigMgr Admin console. The script then moves the new collection to the new folder. Additionally, there is demonstration of some of the options you can … Continue reading “Creating ConfigMgr Console Folders and Collections with PowerShell”