Parse parameter default values using PowerShell – Part 1 Aaron Bertrand talks about a new project involving parsing the default values for parameters out of stored procedure and function bodies. Aaron Bertrand ◆ September 25, 2020 1
Fundamentals of table expressions, Part 6 – Recursive CTEs Continuing a series on table expressions, Itzik Ben-Gan explains recursive CTEs, features from the standard T-SQL is lacking, and workarounds. Itzik Ben-Gan ◆ September 9, 2020 0
Please stop using this UPSERT anti-pattern There is a very common anti-pattern you should avoid, involving updating a row if it exists and inserting it if it doesn't. See how to avoid race conditions and deadlocks. Aaron Bertrand ◆ September 2, 2020 5
