See how performance optimization in 4 hours follows focused triage, reviewed fixes, and a written action plan for the work that remains.
Consulting 102 – What Do I Promise in Every Engagement?
Know what I promise in every engagement, define a useful baseline, and compare performance changes without trusting a speed claim.
Consulting 101 – Why Do I Never Take Control of Computers Remotely?
I avoid control of computers remotely so your team owns each action, protects credentials, and learns a tuning process it can repeat.
Wide Update Plans: What Every Extra Index Costs a Write
Inspect wide update plans, compare index-maintenance work with narrow updates, and read per-index counters without misreading STATISTICS IO.
Recent Rows Only: A Filtered Index for the Data Everyone Reads
A filtered index for recent rows is small and fast, but its date never moves by itself. Here is how to build it, test it and keep it fresh.
Watching Many Servers Without Buying Anything
Use scheduled snapshots to monitor SQL Server with central storage, failure reporting, and four focused queries collected every five minutes.
SQL SERVER – Default Worker Threads Per Number of CPUs
The default Worker Threads limit depends on SQL Server version, logical CPUs and memory. A workshop reader asked about automatic configuration.