Idempotent Data Patches in SQL Server: A Change Tracking Pattern for DACPAC Deployments
If you deploy your SQL Server databases with SSDT or DACPACs via SqlPackage, you have probably run into this problem: the schema deployment is repeatable, but the data patches are not. SSDT handles CREATE TABLE,…
SQL Server hierarchyid: A Built-In Alternative to Recursive CTEs
Learn how SQL Server’s hierarchyid data type stores and queries tree structures without recursive CTEs, with practical examples for org charts and hierarchical data.
Recursive CTEs in SQL Server: How the Parts Actually Work Together
A plain-language walkthrough of recursive CTEs in SQL Server, breaking down the anchor, the recursive member, and the iteration cycle so the syntax finally makes sense.
A Better Cursor Pattern for SQL Server: Cursor Variables and @@CURSOR_ROWS
Replace the traditional WHILE @@FETCH_STATUS cursor loop with a cleaner pattern using cursor variables, STATIC cursors, and @@CURSOR_ROWS for more readable, less error-prone T-SQL.
Should I use (max) size for all my nvarchar/varchar columns?
Should you use VARCHAR(MAX) for all your string columns? No. Here’s why MAX costs you indexing, memory grants, and storage efficiency with demos you can run yourself.
Teaching GitHub Copilot Your T-SQL Coding Standards
If you’re a DBA or database developer using GitHub Copilot CLI, you’ve probably noticed it generates functional T-SQL - but not necessarily T-SQL that matches your team’s coding standards. After several weeks of working with…