Microsoft 365 / Azure

Understanding Outlook Inbox Rule Conditions, Exceptions, and Order: Settings to Ensure You Never Miss Important Emails

Learn how to use conditions, exceptions, rule execution order, and the "stop processing more rules" option in Outlook inbox rules. Using four hypothetical emails as examples, we demonstrate verification procedures to prevent misrouting.
2026.10.15
Microsoft 365 / Azure
VBA / Office

Inspecting Column Structure with Power Query Table.Schema: Detecting Missing Required Columns Before Ingestion

Verify column names, positions, and types using Power Query M Table.Schema, and detect missing required columns using Table.HasColumns and List.Difference. Includes three dummy data examples and official specifications.
2026.10.12
VBA / Office
Programming / Web Development

Aborting fetch in JavaScript with AbortController – Request timeout and cleanup

Demonstrating how to abort JavaScript fetch requests using AbortController with a Node.js localhost server. Also explains the differences between AbortError/TimeoutError and HTTP 500.
2026.10.12
Programming / Web Development
Linux / CLI / DevOps

Tracking configuration sources with git config –show-origin: Precedence of system, global, and local

Where Git's user.name comes from. Using --show-origin and --show-scope in a temporary repository, explaining the difference between local and command, and addressing secrets in CI.
2026.10.12
Linux / CLI / DevOps
PowerShell

Standardizing Full-Width Alphanumeric Characters with PowerShell Unicode Normalization NFKC – A Non-Destructive Method for Source Data

Using .NET Normalize(FormKC) in PowerShell to unify full-width alphanumeric characters and half-width kana. Explains the differences from NFC and precautions regarding ID collisions.
2026.10.10
PowerShell
Programming / Web Development

Comparing SQLite's PRAGMA quick_check and integrity_check: Detecting database corruption via read operations

Explores the differences between SQLite's quick_check, integrity_check, and foreign_key_check using an in-memory database, explaining why an 'ok' result can still miss foreign key violations.
2026.10.10
Programming / Web Development
Networking / RFC

Observing HTTP 103 Early Hints on localhost: Verifying the difference from 200 using Node.js and curl

What is the difference between HTTP 103 Early Hints and 200? Observe localhost communication using Node.js and curl. Explanations cover RFC 8297 and the boundary between preloads and final responses.
2026.10.10
Networking / RFC
VBA / Office

Combining Multiple Tables with Excel HSTACK and VSTACK – Handling Empty Cells and Mismatched Column Counts

Compare through practical examples where #N/A occurs when combining tables with differing row or column counts using Excel HSTACK/VSTACK, and how to use IFNA.
2026.10.10
VBA / Office
Linux / CLI / DevOps

Predicting next execution time with systemd-analyze calendar – Differences between OnCalendar and Persistent

Calculate the next execution time of a systemd timer without changing configurations. Review OnCalendar timezone specifications, Persistent, AccuracySec, and differences from actual services.
2026.10.10
Linux / CLI / DevOps
Programming / Web Development

Safely replacing CSV files in Python: Preserving original data even if write fails mid-process

A practical example of safely updating CSV files in Python using tempfile and os.replace. It introduces code that preserves the original file even if an error occurs during writing, along with three unit tests.
2026.10.10
Programming / Web Development
Next page