Investigate dead code with cached procedure statistics, dependency checks and retained snapshots, then quarantine candidates before removal.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
BULK INSERT ORDER Hint: Loading Pre-Sorted Files Without a Sort
The ORDER hint does not sort anything. It is a promise about your file, and SQL Server checks it. Here is what happens when you break it.
Interview Question of the Week #048 – How to Move TempDB to Another Drive?
Can TempDB be moved to a different drive? Yes. Here are two reasons to do it and the exact steps to move TempDB to another drive.
SQL SERVER – Resource Governor and Database Mapping
At SQLPass, an attendee asked how InMemory databases use memory. I show how Resource Governor and database mapping let you bind a database to a resource pool.
SQL SERVER – 2016 – Opening JSON with OPENJSON()
The next step with JSON in SQL Server 2016 is reading it. OPENJSON parses JSON text and returns properties as rows. A simple example with the default schema.
SQL SERVER – Could Not Register Service Principal Name Persists – Notes from the Field #105
Seeing ‘Could not register the Service Principal Name’ in your SQL Server log at startup? In Notes from the Field #105, Ryan Adams explains why and what to do.
SQL SERVER – XEvents to Find Cardinality Estimation Issues
Is there a way to find cardinality estimation issues? I use the query_optimizer_estimate_cardinality XEvent to see how each operator’s estimate is derived.
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.