A Technical Demo fails for a few predictable reasons, and most of them can be fixed before you start. This guide covers rehearsing on the exact machine, numbered scripts with a reset file, readable screens, an early room check, a recorded backup and what to say when something breaks live.
SQLAuthority News – Meeting with Allen Bailochan Tuladhar – An Unlimited Experience
My 9-day trip to Nepal with Allen Bailochan Tuladhar, who keeps Nepal’s tech community moving. Every day was a new lesson, truly an unlimited experience.
SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010
My review of TechMela Nepal in Kathmandu, March 29 to 30, 2010: around 500 students, hundreds of tech professionals and nine great days with Allen Tuladhar.
SQLAuthority News – Milestone of 1300th Post and A Few Updates
My 1300th post looks back at how SQLAuthority began as a list of personal bookmarks and scripts, and shares a few updates about the blog.
What Is Locking and Blocking in SQL Server?
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.










