Shawn McGough

Airflow + SQL Server = 💘

Dockerfile for Airflow + SQL Server (mssql)

Hashcat: How to Change Device on a Session Restore

Hashcat restore was defaulting to a device ID that was no longer the correct one. I needed to update the device IDs. Specifically, I needed to add two new command line options...

Azure

Adding IP Address Space to a Peered VNET

Automate the process of un-peering, adding ip space, and re-peering on Azure vnets.

DevOps

Creating a Microsoft-hosted Agent on your VNET

I located the scripts that Microsoft uses to build their build agent virtual machines. With these, I can build the same exact images that are used for Microsoft-hosted agents.

Azure

Azure SQL Server Auditing: Setting Log Analytics Destination

Recently, I was having some trouble getting Log Analytics set as the destination for Azure SQL Server auditing via the ARM Template for server-level auditing. Early attempts would enable the auditing, but the Log Analytics workspace would be blank. Eventually I discovered the solution, so I'm documenting the process here

DevOps

Power BI: Cannot Set Credentials on RDL Reports [SOLVED]

Using Power BI REST API to Set Credentials on Power BI Paginated Reports

Azure

Azure DevOps: Resolving 'Conflict Prevents Automatic Merging'

A two minute tutorial on how to resolve a pull request merge conflict.

Azure

Azure: It's Time

Never make fun of someone if they mispronounce a word. It means they learned it by reading. Who can't relate to getting call out on the mispronunciation of a word? It cuts deep. Time slows down as you focus on a single thought: you sounded like a fool - in

Azure

Broadcasting with Azure SignalR Service Management SDK

Azure SignalR is a fully-managed scalable service that adds real-time functionality to applications. It has lowered the bar to building high-frequency data flows with large numbers of concurrent connections. Most commonly, these applications are browser-based web apps with two-way messaging. However, that is only one of the many possible use