This Policy Based Management Quiz asks which evaluation mode can stop a bad change before it is saved. The answer is On change: prevent. A tested T-SQL script blocks a badly named table and shows how few facets support that mode.
CHECKPOINT Behavior Quiz: What Lets the Log Be Reused?
This CHECKPOINT Behavior Quiz asks what lets SQL Server reuse transaction log space under the SIMPLE and FULL recovery models. The answers differ, and a tested script shows both. It also shows how one open transaction keeps the log from being reused.
SQL Assessment API Findings: From Scan to Action
SQL Assessment API findings can guide a health review, provided the scan’s scope and evidence are clear. I separate collection problems from recommendations before deciding what to change. A short list is useful only when I know what was checked.
SQL Server Health Check: Six Checks to Prioritize
A SQL Server health check becomes useful when its findings lead to a clear, justified next step. I start with recovery and access risks before tuning preferences. A warning deserves investigation, but it does not automatically justify a server change.
Diagnosing a Frozen Server With the Dedicated Admin Connection
The dedicated admin connection provides a narrow emergency path to a stalled SQL Server; prepare remote access and keep diagnostics light.
Setting MAXDOP and Cost Threshold Sensibly
MAXDOP and cost threshold work together to shape parallel plans; inspect current values, test a change, and watch real workload effects.
Finding Misconfigurations With One Script
Finding misconfigurations With One Script checks SQL Server settings that deserve a review, with recommendations tied to workload and evidence.