You Need a DBA Pipeline

Steve notes that DBAs need a privileged pipeline, separate from what they might use to update database schema.

Checking the Error Log II

The Disabled Index

The Costs of Multiple Platforms

Lots of organizations use multiple database platforms. Steve notes there is a cost to choosing to allow this.

Tracking All the Queries

Database Animations: The Difference Between Row Compression and Page Compression

What's the difference between SQL Server's row compression and page compression, and when does each one make sense?

How a SQL Server backup can execute attacker code during restore

CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with sysadmin privileges during a routine RESTORE DATABASE operation.

Transaction Log Truncation

How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager

Read a story about how one company saved substantially on their cloud costs with a few simple changes and no interruptions to service.

Never is Not the Policy

Are there things you should never change or configure? Steve notes that is probably not the best policy.