SSAS cube performance diagnosis starts with the exact slow request. Follow storage, MDX calculations, cache, processing, and resource evidence before choosing a fix.
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.