A partner asks for JSON from your XML export. Build the nested shape, decide what an empty order looks like, and avoid the escaped-array surprise.
What a Preview Build Is For, and What It Is Not
Use a SQL Server preview to test specific features and report reproducible issues while keeping production data and recovery paths separate.
AT TIME ZONE Cost: Converting Many Rows Without Burning CPU
Converting a whole column with AT TIME ZONE looks harmless on three rows and hurts on a hundred thousand. Here is the cheaper way to filter a local day.
Scalar Functions and Performance
Scalar functions can hide row-by-row work in SQL Server; learn when inlining helps, how to inspect eligibility, and when a set-based rewrite wins.
What Lock Escalation Is and How to Stop It
Understand lock escalation, confirm it with evidence, and reduce its impact through smaller transactions, better access paths, and modern locking.
EXECUTE AS OWNER in Stored Procedures: Power and Pitfalls
A procedure with owner rights can write to tables its caller cannot touch. Watch the identity change, and see how one careless parameter hands out too much.
SQL SERVER – Table Valued Functions – Day 26 of 35
Let us learn about table valued functions. Every day one winner from the United States will get Joes 2 Pros Volume 4.