Blog

• Build a Power BI Segmented Progress Gauge With Deneb and Vega

  Build a segmented progress gauge visual in Power BI using Deneb and Vega. Includes the complete JSON specification and steps to connect data.

• Build a Power BI Progress Thermometer With Deneb and Vega

  Build a progress thermometer visual in Power BI using Deneb and Vega. Includes the complete JSON specification and steps to connect data.

• Install WordPress on a Debian LAMP Stack

  Install WordPress directly in the document root of a Debian LAMP stack running Apache, PHP-FPM, and MariaDB.

• Build a Power BI Timeline Visual With Deneb and Vega

  Build a multi-project milestone timeline in Power BI using Deneb and Vega. Includes the complete JSON specification and steps to connect data.

• Using AI to Review Blog Posts and Knowing When to Stop

  I used AI to review two years of blog posts for accuracy, technical gaps, and consistency. The process will change how I approach future reviews.

• Automate Maintenance on a Debian LAMP Stack Using a Bash Script

  Automate maintenance on a Debian LAMP server hosted on Amazon Lightsail with a Bash script that creates snapshots, updates packages, restarts services intelligently, and cleans logs.

• Upgrade PHP on a Debian LAMP Stack

  Upgrade PHP on a Debian LAMP stack running Apache and PHP-FPM, with steps for Apache reconfiguration, verification, cleanup, and troubleshooting.

• Install and Harden a Debian 12 LAMP Stack on Amazon Lightsail

  Guide to installing and hardening a LAMP stack on Amazon Lightsail with Debian 12 and PHP 8.4, covering Apache, PHP-FPM, MariaDB, HTTP/2, and Let’s Encrypt SSL.

• Power Automate: Copy SharePoint Multi-Person Fields Using Claims

  Copy SharePoint multi-person fields in Power Automate by extracting Claims values and rebuilding the person field as an array of user objects.

• Using AI to Modernize a 30-Year-Old QBasic Game for the Web

  I found a QBasic game I wrote in 1996 and used AI to rebuild it for the web with JavaScript, HTML5 Canvas, and modern features.

• Remove System Prefixes in SharePoint Lookup Columns

  SharePoint lookup columns create dependent fields with system prefixes. Remove prefixes and understand internal vs. display name behavior.

• Delete SharePoint List Items in Power Automate: 3 Methods

  Compare three ways to delete SharePoint list items in Power Automate using Delete item, REST API, and Batch API for high-volume scenarios.

• Prevent Infinite SharePoint Trigger Loops in Power Automate

  Prevent infinite SharePoint trigger loops in Power Automate flows using trigger conditions, flags, and proven patterns to stop repeated updates.

• Remove Lookup Column Links in SharePoint

  Remove clickable links from SharePoint lookup columns using JSON formatting to keep list views clean and prevent unwanted navigation away from the list.

• Automatically E-mail Power BI Dashboard Screenshots

  Schedule Power BI dashboard screenshots by e-mail using Power Automate and bookmarks, without any custom code or third-party tools.

• Power Query: Load Excel Data From Local, Web, or Current Workbook

  Load Excel data into Power Query from local files, SharePoint, or the current workbook, including tables, worksheets, and named ranges.

• Excel Multi-Criteria Lookup Guide

  Compare Excel multi-criteria lookup methods using SUMPRODUCT, INDEX with MATCH, and XLOOKUP with practical examples.

• How to Create a Multi-Resolution favicon.ico File

  Create a multi-resolution favicon.ico using Inkscape and ImageMagick, with step-by-step instructions for exporting PNG sizes and building the final ICO file.

• How to Add Math Equations to Astro With KaTeX

  Add math equations to Astro using KaTeX with Markdown examples, setup steps, and styling tips for clean static site rendering.

• Java Permutation Generator: Partial and Full Strings

  Generate partial and full string permutations in Java using an iterative, duplicate-safe approach with examples.