Technology Solutions for Everyday Folks

Matt Zaske Online Blog

Implementing DMARC for Active Domains: Configuring Prerequisites

As a follow-up from my previous post about implementing DMARC controls for unused/alias domains (those not used for actively sending messages), I wanted to write a bit about how to implement basic DMARC controls for those domains actively used to send emails.

Read More

Armchair Pair Programming

This past Friday, somewhat out of the blue, I was pinged by a friend about helping him work through implementing what I'd done to date with Certbot...with the additional twist of his own unique configuration challenges.

Read More

Implementing DMARC on Alias Domains

A few weeks ago I crossed a tweet with some simple instructions for securing your "unused" email domains, specifically the few bits required to implement DMARC controls to prevent Bad Folks from using your domains to send spam emails.

Read More

That's a [House] Wrap!

Charlie the cat enjoying the outdoor smells.

As I'd eluded in a post earlier this summer, we had some major home projects completed this year. As of the end of October, 2020, they're all functionally complete. We only await the delivery and installation of a few missing pieces of window jamb extensions and casing, and a "rainy day" for the contractor to spend a couple quick hours installing.

Read More

Automating Certbot: A Recap of My Journey

Long winding road

Over the last two months, I've shared what amounts to a four-part "series" of posts walking through my journey of using Certbot for SSL certificate management, with the primary challenge being not having the traditional root-level access on the web server. Those posts are, in order:

Read More

Certbot in Manual Mode with Script Hooks

If you've been following along in the mini series, I've gone over the details of using Certbot in manual mode, then bolting some simple scripts together to improve the process of generating and managing certs, all done with a bit of magic thanks to our old friend <

Read More

Improving Manual Certbot Domain Validation

In my second post about using Certbot in manual mode, I address some of the 'pain points' from the first post: namely the process of scripting together some of the bits to create/renew a certificate and otherwise requiring fewer individual commands be entered (or remembered).

Read More

Moving to Certbot with Let's Encrypt

This is the first post in a short series of posts about automating what one can in an environment that might not support full-automation with Certbot and Let's Encrypt.

Read More

Analog Reading

I read and consume a lot of material every day. I love it, and I love how available this material can be to everyone (God Bless the Internet).

What I have been remarkably remiss at over the last year or so, though, is regular old analog reading. The stuff of books, that is.

Read More

Quick Tests of WQL Queries

Recently I was working on a clean-up/improvement project in the MEMCM (SCCM) console which required some WQL query work and updates. In particular, I was fiddling with some collection queries to segment some areas for a process improvement project coming up. That's intentionally vague, because the 'why' in this case doesn't really matter. What does matter is that I needed WQL to give me proper results.

Read More

A Good, Long Conversation

Throughout the pandemic I've tried to keep in contact with friends via different mechanisms. One of those venues is Slack, where one friend and I have gotten into this "habit" of sorts where we do some sort of video call (Slack, Zoom, etc.) that ends up lasting several hours. These come up every six weeks or so (in addition to more regular banter via Slack); not often enough to be burdensome, but often enough to be meaningful.

Read More

Quickly Extracting Icons with Powershell

One of the things I both love and loathe is adding the little icon to an advertised deployment in the Software Center console of SCCM/MEMCM. As many have said it in the past, "Pretty Counts" and I wholeheartedly agree.

Read More

Auto-Power On Dell Workstation

Cartoon characters join together with "Let's Power Up!" as a caption.

As we begin another academic year, this time in a pandemic, we're providing more virtual/remote desktop access to computer lab and public-access workstations for those in need. We're starting by using the machines taken out of general service due to physical distancing requirements.

Read More

Formulas in CSV Files

Bad Magic Trick with a ladle for cooking

A while back I received a call for assistance in helping to streamline an inherited process. In this particular case, an individual had created a complex (but necessary) process to essentially transform and move data between disparate systems. The employee(s) responsible for creating this process had since left, but the process remained and needed to be manually done often enough that it was painful enough for the person now responsible for the process to ask for assistance.

Read More

All Sealed Up!

Injection foam insulation breaches an electrical outlet.

It's been a wild couple of weeks since I last posted anything here. I'd exhausted most of pre-written content and with a bunch of these improvement and scope creep projects on the horizon it was not feasible to get more material churned out in the short term, so a break it was!

Read More

Improvement Project Scope Creep

As I've written about before, there have been plenty of random projects to work on during the pandemic and additional time spent around home. Due to a pretty significant hailstorm last summer, we're going to be replacing every roof on the property and also re-siding the house.

That's not where the scope creep comes into play.

Read More

Setting Up Key Authentication

Hands playing with a set of keys on a ring.

While I was preparing to write an upcoming post about moving directly to certbot from SSLForFree now that they've merged with ZeroSSL, I realized that I'd not actually ever written a post about one of the components I use all the time, including for my new certbot process: public key authentication.

Read More

Pollinators on the Prairie

Large bumble bee resting in a shady spot.

One of the things I've always enjoyed about our little home on the prairie is the fact we've always a selection of various critters or insects beneficial to the larger environment. Part of this is bolstered by the fact we live across the road from several hundred acres of waterfowl production area owned and managed by the US Fish and Wildlife service.

Read More

Pushing Data Into Google Sheets Sheets (Yes, Multiples)

Screenshot of basic sheet including multiple tabs/sheets (Excel)

If you recall from the last tech post about pushing data directly into Google Sheets, I promised a follow-up regarding the process of adding multiple sheets worth of data to a given parent sheet.

Read More

Interesting Pandemic Electric Usage Pattern

Stock bar graph with trend arrow ending downward

This is a relatively short post, but as I entered our May electric usage into my tracking spreadsheet (see the Energy Use Analysis post from a while back), I noticed something peculiar about this last few months since the pandemic really hit (and we started staying at home all the time).

Read More

Programmatically Push Data to Google Sheets

Screenshot of a very basic CSV file of gibberish test data

I've written in the past about the ability to ship files to Google Drive via its REST API and PHP, which is a super-cool process in and of itself. In the last few months, I've been moving more and more of our internal data shipping processes to Google Shared Drives for ease of end user access.

Read More

Pandemic Projects Aplenty

Tim Allen from Home Improvement showing off sledgehammer

It is no surprise to me that retail outlets catering to home improvement projects have been doing well during the pandemic and various iterations of stay-at-home orders. The sudden 'found' time of folks who might normally spend time on other endeavors is suddenly focused into projects around the house. To some degree this is the same here...

Read More

Character-Perfect Fixed Width Import Files

Flintstones Cartoon Sewing Machine

One of my springtime projects at work was to button up a recently-refreshed process to transmit some billing data between systems. By 'recently-refreshed,' I mean 'finally made a process whereby a human doesn't have to manually generate a file which had been the de-facto process for the better part of twelve years. Due to the cascading effects of some staff turnover in the unit in question, IT was brought into the loop to help find a better way to work this process.

Read More

Shaking The GnuCash Account Tree

Man shaking tree of money

Over the years I've developed a habit where a short part (~30 minutes on average) of most weekends are dedicated to entering the week's receipts, reconciling (or balancing) accounts, updating investment fund values, and so forth. Once familiar with GnuCash, this process is pretty straightforward and easy to do.

Read More

Simple, Yet Powerful Excel/Sheets Functions

Cartoon about functional programming

As a reflection exercise for a project I wrapped up a bit ago, combined as an exercise to make Future Me's life a Better Place, I pulled together a simple Google Sheets workbook to make a quick 'calculator' and balancing mechanism to help keep track of a couple datasets. And in so doing, I again befriended a couple of super simple, and super powerful functions:

Read More