Locking and blocking are not the same thing, and the difference is the whole subject. I blocked a session on purpose and read it from the DMVs. Why short blocking is healthy, and why NOLOCK fixes nothing.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot
A Snapshot database is a read-only, static view of a source database. I explain how it works and how to restore a database from a snapshot.
SQL SERVER – Enable Identity Insert – Import Expert Wizard
An SSIS package failed with an identity error because both tables had identity columns. Checking Enable identity insert in the Import Expert Wizard fixed it.
SQL SERVER – Difference Between GRANT and WITH GRANT OPTION
What is the difference between GRANT and WITH GRANT? Only WITH GRANT OPTION lets a user pass the same permission on to other users.
ISJSON Type Constraints: Validate the Top-Level Value
ISJSON type constraints distinguish JSON shapes. Compare VALUE and SCALAR, Boolean literals, JSON null and SQL NULL on SQL Server 2022.
float vs decimal: Why Money Should Never Be float
Compare float vs decimal for currency, inspect approximate arithmetic, and use explicit decimal precision and rounding rules.
SQLAuthority News – Fun Quotes about Technology
SQL Server can be a boring subject at times, so here are some fun quotes about technology from Thomas Edison, Douglas Adams and others to lighten the day.
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.