The skills that make a DBA hard to replace combine tested recovery, careful performance work, useful automation, and clear communication.
Keeping Personal Data Out of Test Databases
Keeping personal data out of test databases requires synthetic records or masking during refresh, plus verification before access.
Baselines: Knowing What Normal Looks Like
Build a SQL Server baseline with timestamped workload, wait, and IO samples so you can compare a slowdown with a similar period of normal work.
SQL SERVER – Delete Backup History – Cleanup Backup History
SQL Server keeps backup history in msdb forever. Use sp_delete_backuphistory to delete backup history older than 30 days, or any number you pick.
SQL SERVER – Check Database Integrity for All Databases of Server – DBCC CHECKDB
A quick script to check database integrity for all the databases on a server with DBCC CHECKDB and sp_msforeachdb, and how to read its output.
Why WHERE Runs Before SELECT
Learn logical query processing to understand WHERE, SELECT aliases, grouped filters, and ordering without confusing syntax with execution.
SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server
SQLAuthority.com crossed 5 million visitors and turned 2 years old. I also share my note on the economy slow down and job opportunity for SQL Server folks.







