SSAS cube performance diagnosis starts with the exact slow request. Follow storage, MDX calculations, cache, processing, and resource evidence before choosing a fix.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Too Many Indexes on One Table
Too many indexes on a SQL Server table can slow every write; learn how to identify overlapping indexes, measure their value, and remove them safely.
SQL SERVER – First Month as DBA Trainee – Disasters and Recovery
For T-SQL Tuesday on disaster and recovery, I share the lessons I learned in my first month as a DBA trainee, like never zipping native backups.
XQuery Node Order: Compare Source Document Positions
XQuery node order compares positions in an XML document, not their text. Source order, alphabetical order and a node compared with itself give different answers.
geometry STAsBinary: Carry the SRID Beside the WKB
geometry STAsBinary exports a geometry as WKB, while reconstruction takes a separate spatial reference identifier. I carry that identifier beside the bytes. Supplying a different identifier creates a differently tagged value from the same exported coordinates.
SQL SERVER – Integration Services Balanced Data Distributor – SSIS Balanced Data Distributor
The SSIS Balanced Data Distributor (BDD) spreads incoming rows across outputs with multithreading. How it works and the scenarios where it improves performance.
Destructive Reads: Pulling Work From a Queue Table With OUTPUT
Claiming a job and finishing it are two different things. Try a delete claim, a rollback, and an update claim on a tiny queue.
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.