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.
How to Track Data Platform Service Level and Performance Before and After Consolidation?
Planning data platform consolidation? Track service level and performance before and after consolidation, so you know how well the planning worked.
SQL SERVER – Error: 825 – A Read of the File at Offset Succeeded After Failing 1 Time(s)
One of my clients contacted me to give advice about an error. In this blog, we would discuss error message – A read of the file at offset succeeded after failing 1 time(s)