Learn four practical window functions with SQL examples for numbering rows, ranking ties, comparing previous values, and calculating running totals.
SQL SERVER – Understanding Restrict Access to Restricted_User Database Property
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.
Rewriting OR Conditions So the Index Gets Used
Rewrite OR conditions with separate seeks, preserve duplicate and NULL behavior, and compare plans before choosing UNION or recompilation.
SSRS Parameters That Do Not Slow Reports
SSRS parameters work best with selective defaults, compact value lists, and SQL queries that preserve useful indexes under real filters.










