Turning a Folder of DBA Scripts into a PowerShell Module
Package one-off DBA PowerShell scripts as a module: .psm1, .psd1 manifest, explicit exports, PSModulePath and side-by-side versions, tested in 5.1 and 7.
Trigger Archaeology: Mapping Nested and Recursive Trigger Chains
Map which SQL Server trigger writes to which table before you change a legacy schema, and see what happens at the 32-level nesting limit.
Configuration Drift Between SQL Server Instances: Comparing sys.configurations to a Saved Baseline
Save sys.configurations from each SQL Server instance to a baseline table, then find options that differ, are missing, or need RECONFIGURE or a restart.
Where MongoDB Schema Validation Actually Lives
MongoDB can enforce a schema, but only if you ask. I tested its validation options on 8.0 and 9.0 and compared them with SQL Server constraints.