SSMS keyboard shortcuts for execution, comments, results, and Object Explorer remove repeated clicks while keeping query context visible.
MYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName
Cannot drop a MySQL table or database because a foreign key constraint fails with error 1217? Turn off FOREIGN_KEY_CHECKS, drop it, then turn checks back on.
Idempotent Deployment Scripts: Safe to Run Twice
Build idempotent deployment scripts with guarded schema changes, versioned data fixes, and repeat-run checks for the intended state.
SQL SERVER – Virtualized SQL Server Performance and Storage System – Notes from the Field #013
Tuned everything in a VM and still slow? In Notes from the Field #013, David Klee explains Virtualized SQL Server Performance and the storage behind it.
Comparing Data Between Two Tables
Comparing data between two tables uses EXCEPT, full joins, and hashes, with explicit NULL and duplicate rules for trustworthy results.
Stopping Duplicate API Requests With an Idempotency Key Table
Store an idempotency key with its order in one transaction, return the committed result on retries, and define key reuse and expiry rules.
DOP Feedback: Letting SQL Server Lower Parallelism by Itself
Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.