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.
How Does QUOTED_IDENTIFIER Works in SQL Server? – Interview Question of the Week #217
How Does QUOTED_IDENTIFIER Works in SQL Server? I explain it in very simple words, using SELECT “Order By” with the setting OFF and then ON.
SQL SERVER – Read Only Routing Error: Client Unable to Establish Connection Because an Error was Encountered During Handshakes Before Login
A client’s Always On read-only routing failed with: an error was encountered during handshakes before login. Here are the checks I shared and how we fixed it.
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.