OpenVPN based Site-to-Site VPN between Azure and pfSense

This post explains how to quickly setup a simple site-to-site VPN to connect on-prem network with an Azure virtual network using OpenVPN community edition running on Windows VM in Azure. One can use firewalls like pfSense on-prem that support OpenVPN client, or setup a Windows server as OpenVPN client.

Get Incidents Containing a Specific Keyword from SCSM

SQL query in this post will get all incidents containing “print” keyword, along with analyst comments from Service Manager operational database. Comments are not available in data warehouse by default.

Map Shared RDMs using PowerCLI

This post provides PowerCLI scripts and explains the process to automate mapping of hundreds of Shared RDMs (Raw Device Mappings). Useful in DR scenarios.

SCOM: PowerShell Script to Get All Overrides

Script to Export overrides to CSV. Additional parameters to specify sealed/unsealed MPs, credentials, MP name filter, and uses OperationsManager PS module.

Installing HAProxy on pfSense

HAProxy and pfSense are both wonderful solutions on their own. This post explains three solutions to integrate them. These solutions range from a typical testing scenarios to a more maintainable, secure, full featured, flexible and viable solution for critical production environments.

SQL Blocking – Troubleshooting In Transaction User Interactions

This Post Explains How To Troubleshoot and Fix Applications causing SQL Blocking doing User Interactions inside SQL Transactions.