Backing up MySQL means choosing logical or physical copies and retaining binary logs for point-in-time recovery, then testing restores.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
9 Things You Should be Doing with Your Backups – Backup Tips – SQL Server Backup Tips
Nine SQL Server Backup tips every DBA should follow, starting with the simplest one: never keep backups on the same physical drive as the database files.
SSMS Keyboard Shortcuts Worth Learning
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.