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.
Networking / RFC

Delimiting "one message" in TCP: Trying length prefixes on localhost

We test a length prefix, which adds a 4-byte length to the TCP byte stream so the receiving side can determine message boundaries.
Linux / CLI / DevOps

What is the difference between symbolic links and hard links? — Understanding through inodes

Create two types of links in a temporary directory and understand their differences based on inodes and behavior after deleting the original file.
PowerShell

How Many Threads Are in a Process? — Observing Reality with PowerShell

Read the current PowerShell process and observe how multiple threads exist within a single PID.