Async updates save hours when each message carries everything the reader needs. This post shows the five fields of a clean update, a made-up example and a default action that keeps work moving. It also says when a meeting still wins.
Finding Out Who Changed That Row
Investigate who changed data using existing audit evidence, transaction log limits, and the distinction between logins and individual users.
Finding Where an Object Is Used Across a Database
Use dependency metadata, definition searches, and runtime evidence to find object usage while accounting for dynamic SQL and external callers.
Circular Foreign Keys: Inserting Rows That Point at Each Other
Two tables point at each other, and every insert fails. Here is the nullable column that gives you a way in.
Giving Every Developer a Dedicated Development Database
Set up a dedicated development database from approved schema scripts and clean seed data, with repeatable rebuilds and drift checks.
Extracting the Folder and File Name From a Full Path in T-SQL
Split a path at the last backslash and handle the odd inputs. Bare names, empty values, trailing spaces and NULL all behave.
Context Switching Has a Cost: Batch Your Interruptions
Context switching costs more than the seconds it takes to change windows. This post compares attention with SQL Server commits: pay the fixed fee once per batch, not once per ping. It gives concrete ways to batch messages, tickets and reviews, and ends with a short checklist.







