What does Restrict Access set to Restricted_User mean in database properties? I answered a reader with a simple image comparing it with Multi_User and Single_User.
IS DISTINCT FROM in SQL Server 2022: NULL-Safe Comparisons
Use IS DISTINCT FROM for NULL-safe comparisons in SQL Server 2022, understand older workarounds, and inspect index seeks before changing code.
SQL SERVER – Disk Space Monitoring – Detecting Low Disk Space on Server
A common question I get: how do you go about detecting low disk space on SQL Server? Here are two ways, including xp_fixeddrives, and the one I prefer.
A Crossword Helper in T-SQL: Matching Word Patterns With LIKE
Match word patterns with LIKE and SUBSTRING, build sorted-letter anagram signatures, and use a leading-letter index for crossword searches.
Adding System Versioning to a Table That Already Has Rows
Turning on temporal history for a table that already has data does not rebuild the past. Here is the clean way to do it, and the traps to avoid.
SQL or NoSQL for a New Project
Choose SQL or NoSQL for a new project by testing data shape, consistency needs, query patterns, and the skills the team can operate.
Profitable Blog: How a Technical Blog Pays for Itself
A profitable blog starts with readers who trust the writer. This post shows how a technical blog pays for itself through ads, consulting and books. It ends with a short checklist for your own blog.