A table is not simply compressed or not. Here is how to read the setting for each index and partition, and the mistake that leaves indexes full size.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Updating Data in A Columnstore Index
A reader got an error when updating data in a columnstore index table. Here is why the table becomes read-only and what you can do about it.
SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default
Someone changed the keyboard shortcuts in my SSMS 2012 at a conference. Here is how to reset keyboard shortcuts back to the default settings.
Splitting Work Into Equal-Sized Batches With NTILE
NTILE deals 100 customers into eight batches in one query. The catch is keeping those batches stable while new rows arrive.
How to Read a Stored Procedure You Did Not Write
Learn to read stored procedure code by tracing inputs, writes, transactions, errors, and dependencies before trying to understand every line.
Interview Questions That Actually Reveal SQL Skill
Use SQL Server interview questions that reveal reasoning about joins, NULLs, performance, and recovery instead of rewarding memorised trivia.
CODEPAGE 65001: Importing UTF-8 Text Files Without Garbled Accents
Your import turned Élodie into odd symbols. Here is how CODEPAGE 65001 fixes the reading, and why the column type still matters.
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.