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 – 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.