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

A Limited Startup

Why SQL Server Database Attach fails and how to repair it

This article covers a few common errors when attaching database files to an instance, with some information on how to resolve the issues.

The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server

From bloated error logs to risky logon triggers, a guide to auditing connections without killing performance.

Make It Routine

One of the goals of software is to use the power of the computer to handle repeatable tasks. Steve notes that this can be hard at first, but the goal is that subsequent efforts become routine.

DBCC CHECKDB Limits III

SQL Agent Job Automated Change Capture Process

Build a process that captures your SQL Agent job history and changes across time.

Finding a Database Master Key