I avoid control of computers remotely so your team owns each action, protects credentials, and learns a tuning process it can repeat.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
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)
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.