Use the JSON data type in SQL Server 2025, reject invalid documents, read and change properties, and choose where relational columns fit.
SQL SERVER – Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group
Migration of SQL Server 2012 database mirroring to AlwaysOn Availability Group can be tricky. Here is the setup and the migration process, step by step.
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.
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.