papanda925

Networking / RFC

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

Establish a TLS connection from PowerShell using TcpClient and SslStream, and read-only check the Subject, NotAfter, and remaining days of the presented certificate.
PowerShell

Verifying if Two Files Are Truly Identical: Using SHA-256 in PowerShell

Compare the SHA-256 hashes of two files using Get-FileHash in PowerShell, and safely observe the differences compared to file size checks and the drastic changes in the digest when a single character is modified.
Microsoft 365 / Azure

What is the difference between Microsoft 365 Business Premium and E3? Choosing based on the 300-user limit, Windows, and management features

A practical comparison of Business Premium and Microsoft 365 E3 covering the 300-user limit, Windows Enterprise, management features, storage, and current pricing.
PowerShell

What is the Difference Between Win32, COM, and WinRT? Organizing the Three Windows API Worlds from PowerShell

We compare the entry points from PowerShell to Win32, COM, and WinRT, and organize how to distinguish them regarding naming, types, lifetime, and business automation usage.
PowerShell

[Advanced Tech TRY] Consolidating Duplicate FileSystemWatcher Events: Visualizing Debounce

Observe duplicate FileSystemWatcher events and design separate handling for debouncing, file readiness checks, idempotency, and missed events.
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.