Follow SQL Server blocking_session_id through a blocking chain, identify the head blocker, and choose a safe ending for the wait.
SQL Server for Oracle DBAs: The Vocabulary
SQL Server for Oracle DBAs translates instance, database, schema, tablespace, undo, and redo without pretending the two architectures are identical.
SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle
My notes from SQL PASS 2009 Summit in Seattle: why I went, from networking to putting faces to names, and links to my posts from all four days.
Storage Settings That Matter for SQL Server
Storage settings That Matter for SQL Server include latency, file placement, allocation unit size, and file growth; learn what to verify.
CDC Cleanup and Capture Jobs: Keeping the Log and Change Tables Small
Keep CDC cleanup and capture jobs healthy by checking log reuse, job settings, retention, polling, and a stopped-job alert.
Auditing SELECT Statements on Sensitive Tables
Auditing SELECT statements on sensitive tables needs a narrow database audit, protected files, volume checks, and active review.
Rotating the TDE Certificate
Rotating the TDE certificate protects recovery only when the new private key is backed up and old backups still restore.