One of my GitHub Actions, mssqlsuite makes it ultra easy to install SQL Server on Linux, Windows and macOS runners. When working on the macOS portion, I was surprised that
docker
was not built-in.Turns out, GitHub had to remove docker from the macOS images because of licensing issues.
Workarounds
One of the most …
Read More- Code signing your scripts, modules and applications can help increase enterprise adoption, as large organizations often prohibit running unsigned tools on Windows. Signed code allows machines to verify that what they're running hasn't been altered or compromised by a third party, which ultimately increases their …
Read More I've used ExpressVPN for years and it's worked great on all my devices until one day, when it stopped even trying to make a connection from my Mac Mini.
As soon as I'd hit the connect button, it said it couldn't detect an internet connection -- even though I totally had an Internet connection. So I uninstalled, …
Read MoreYears ago before I learned PowerShell, I was using T-SQL to do things it just wasn't meant to do, namely SQL Server estate management. T-SQL is incredibly efficient when managing data, but it's not very efficient when managing SQL Server instances.
For example, say you need to perform a task against each database. The …
Read MoreThis post is about Import-DbaCsv, a command within the dbatools PowerShell module for SQL Server.
I've been writing about CSV imports using PowerShell for a pretty long time and in VBScript for even longer. Initially, my primary concerns were ease-of-use and speed. Over time, I realized that what mattered most was: …
Read More- Recently, I had to rebuild my proxmox cluster after a disk failure. Against all advice, I installed Proxmox on USB keys. It worked well for ESX so I thought I could get away with it with Proxmox, but alas. Both of my nodes failed after a few months. …
Read More If you're curious about the
$Env:PSModulePath
for GitHub Runners, here's what I came up with after running a workflow.Knowing the
$Env:PSModulePath
of each runner can be useful for making specific types of GitHub Actions. I used it within my own GitHub Action, psmodulecache which makes caching PowerShell modules from …
Read MoreI wanted to blog about this because I couldn't find any info about it on the internet.
Against the advice of everyone, I installed Proxmox on a USB thumbdrive. And, as predicted by everyone who gave that advice, the thumbdrive failed after a couple months.
So I rebuilt my server with a new 1TB SSD disk and a backup of …
Read MoreFor those looking to ensure that their vSphere environments are DISA-compliant, VMware has created a pretty nice repo of tools which help address the nearly 500(!) compliance checks.
The solution is a mixed bag of ansible and PowerShell for remediation and Chef
inspec
for evaluation. I never worked with inspec so I …
Read MoreRecently, while exploring Chef's platform for "Compliance as Code" called InSpec, I ran into an issue when executing VMware's DISA STIG profile against a VMware host.
Sorry, we are unable to detect your platform Train::PlatformDetectionFailed
After connecting to my test vCenter server, I quickly realized …
Read More