Linux / CLI / DevOps

What to Check Before Changing Nginx Configuration? — Using nginx -t and nginx -T Properly

This article outlines a safe sequence for testing configurations with nginx -t before reloading Nginx, and using nginx -T to inspect the entire loaded configuration only when necessary.
2026.09.08
Linux / CLI / DevOps
VBA / Office

Bulk Delete Empty Rows in Excel — Safely Cleaning Only the Target Table with Office Scripts

Using Office Scripts to delete only completely empty rows in a specified Excel table from the bottom up. When multiple tables exist, the target name must be specified to make it harder to accidentally modify other tables.
2026.09.08
VBA / Office
AI & Machine Learning

How Do Filter Bubbles Form? — Running a Simple Model of “Narrowing Recommendations” in PowerShell

We explore the concept of filter bubbles through an educational model in PowerShell consisting of recommendation -> click -> interest estimate update -> candidate reduction.
2026.09.07
AI & Machine Learning
VBA / Office

Saving UTF-8 Without Garbled Characters in VBA — Using ADODB.Stream Without Reference Settings

Call ADODB.Stream from VBA using Late Binding to save UTF-8 BOM-included text to a file. We also organize where and when to use Charset.
2026.09.07
VBA / Office
PowerShell

Catching the Exact Moment a File Arrives in a Folder — Change Monitoring with PowerShell + FileSystemWatcher

Use the .NET FileSystemWatcher from PowerShell to monitor creations, modifications, deletions, and renames in a folder as events.
2026.09.07
PowerShell
Security

Do Not Put Secret Strings in Plaintext Files ― Calling Windows DPAPI from PowerShell

A minimal example of using .NET's ProtectedData from Windows PowerShell 5.1 to encrypt a secret string for the current user and save it to a file.
2026.09.07
Security
Microsoft 365 / Azure

Clean Up Leading/Trailing and Full-Width Spaces in Excel: Fixing Inconsistencies with Office Scripts

Use Office Scripts to format only string values within an Excel table by cleaning up leading and trailing spaces, full-width spaces, and consecutive spaces while skipping formula cells.
2026.09.07
Microsoft 365 / Azure
Networking / RFC

Checking HTTPS Certificate Expiration with PowerShell — Directly Using .NET SslStream

Use .NET TcpClient and SslStream from PowerShell to check the server certificate, expiration date, and remaining days of an HTTPS site.
2026.09.07
Networking / RFC
Linux / CLI / DevOps

Viewing JSON APIs on Ubuntu with curl + jq ― Extract Only the Required Fields in One Go

Combine curl and jq on Ubuntu to extract only the necessary fields from a JSON API response. We will use the GitHub public Repository API as an example.
2026.09.07
Linux / CLI / DevOps
VBA / Office

Extracting IDs, Emails, and IPs from Logs Using Only Excel — Using REGEXEXTRACT / REGEXREPLACE

Using REGEXEXTRACT / REGEXREPLACE in Microsoft 365 Excel to extract IDs and IPs from log strings and easily mask email addresses.
2026.09.07
VBA / Office
Next page