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.

Rebuilding All Indexes

How SQL Server maintenance becomes an attack path – and what to do about it

The article covers four connected areas: over-privileged database users, msdb and SQL Server Agent exposure, privileged maintenance jobs, and trigger-based permission hijacking.

Backing Up a DMK