Replication in SQL Server copies chosen tables to other servers and keeps them current. Publisher, distributor and subscriber in plain words, the three kinds, and why replication is not high availability or a backup.
Bitmap Filters in Parallel Hash Joins: Reading Them in a Plan
Read bitmap filters in parallel hash join plans, compare fact scan output, and distinguish early row rejection from guaranteed savings.
OPTION (FORCE ORDER): When a Join Order Hint Helps and Hurts
Test OPTION (FORCE ORDER) against real join plans, see when fixed table order helps or hurts, and apply a reversible Query Store hint.
Horizontal and Vertical Scaling for Databases
Horizontal and vertical scaling solve different SQL Server capacity problems; compare larger machines, additional nodes, and the costs each brings.
Storing JSON in SQL Server
Storing JSON in SQL Server can use validated nvarchar or the native 2025 json type, with indexed paths and relational columns for stable facts.
Table Variables Survive ROLLBACK: Logging Errors in a Transaction
See how table variables survive rollback to retain error details, then write a permanent error log after a failed SQL Server transaction.
Trigram Matching: Finding Similar Words With an N-Gram Table
Build trigram matching with GENERATE_SERIES and an indexed n-gram table, rank shared pieces, and compare spelling similarity with SOUNDEX.