Change Data Capture cost shows up in places a quick setup never checks. On SQL Server 2025, the same update wrote three times the log with CDC on, the log waited for the capture, and the change table grew to almost four times the table. Here is every number and the script that produced it.
A T-SQL Cheat Sheet for Everyday Work
This T-SQL cheat sheet gathers daily SELECT, JOIN, GROUP BY, window, TRY_CONVERT, and transaction patterns with short examples.
SQL – Difference between != and <> Operator used for NOT EQUAL TO Operation
Is there any difference between != and the ANSI operator for not equal to in SQL Server? A Facebook fan asked, and technically they work the same way.
SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL
A follow up on CONCAT_NULL_YIELDS_NULL: how to check the database level IsNullConcat setting and the session level setting using T-SQL.
Finding Encrypted Stored Procedures Before a Migration
Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.
SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL
A friend ran SET CONCAT_NULL_YIELDS_NULL OFF above every script to deal with NULL columns. Here is a quick note on what it does and what I think of it.
SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes
Dropped an index but SSMS still underlines it in red? Press CTRL + SHIFT + R to refresh the SSMS Intellisense cache and pick up your schema changes.