PowerShell

Advanced Technology TRY: Calling Excel COM from PowerShell – Investigating the True Nature of Excel.Application

Call Excel COM Automation from PowerShell with a minimal smoke test, connecting ProgID, the Object Model, and cleanup to practical use.
Networking / RFC

Sending and Receiving UDP on localhost with PowerShell: Visually Observing Connectionless Communication

Send and receive data on localhost using UdpClient in PowerShell to observe datagram communication, which unlike TCP does not require establishing a connection.
Security

Do not simply sudo AI-generated commands: A 5-stage verification process before execution

A practical procedure for safely verifying AI-generated commands across five stages: verb, target, privilege, expansion, and rollback, prior to execution.
PowerShell

Consolidating Only Photos and Videos from Google Takeout: Automatically Sorting Them into an Out Folder with PowerShell

Consolidate only images and videos into an Out folder from Google Takeout ZIP files and extracted folders. Tested on real data consisting of 2,749 items totaling 15.81 GB, this beginner-friendly guide explains a PowerShell mechanism that tracks progress, remaining item counts, and time remaining.
VBA / Office

Preventing monthly CSV failures from changing column names: Handling column name variations with Power Query M

We test a monthly CSV import process that standardizes only permitted column name variations in Power Query M while ensuring missing columns or unknown changes are not overlooked.
PowerShell

Why Does the Windows Screen Freeze? — Peeking into the Win32 Message Loop from PowerShell

Observe Click events using a minimal PowerShell + WinForms GUI, and experience firsthand why the Win32 message loop and UI thread freeze.
Programming / Web Development

Fixed-length data is hard to understand as text: Use PowerShell to run a hex dump and inspect boundaries

Convert fixed-length dummy records into byte sequences and apply item boundaries, character encodings, and byte-length limits to business file acceptance checks.
Security

What to Remove Before Pasting Production Logs into AI: Testing Safe Sharing Procedures with Dummy Logs

Mask tokens and emails using dummy logs, and establish operational procedures for what to retain and what to obscure before sharing with AI or vendors.
AI & Machine Learning

Preventing AI Character Drift: Creating and Testing a Character Sheet from a Single Image

You try to generate the same character with generative AI, but the face changes slightly every time. I tried a practical method of creating a Character Sheet from a single image, designating papanda925 as the official reference, and changing only the expressions, poses, and scenes.
Networking / RFC

Do Not Follow Redirects Blindly: Inspecting Location Chains with curl

Perform initial triage of SSO flows, shortened URLs, and legacy internal link forwarding paths by observing 3xx status codes and Location headers with curl.