Handle escaping wildcards in SQL Server LIKE searches with brackets, ESCAPE, and a reusable function that preserves literal input.
Integer Division in T-SQL: Why Your Percentages Come Out Zero
Fix integer division in T-SQL percentages from COUNT, SUM and window calculations with decimal types and rounding at the right step.
Converting Deprecated TEXT, NTEXT and IMAGE Columns Safely
Inventory deprecated TEXT, NTEXT and IMAGE columns, convert to MAX types, move small values in row, and measure logging and space costs.
Keeping ACID Across More Than One Server
Understand a distributed transaction through two-phase commit, uncertain outcomes, coordinator recovery, and alternative business guarantees.
The Four Window Functions You Will Actually Use
Learn four practical window functions with SQL examples for numbering rows, ranking ties, comparing previous values, and calculating running totals.
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.