Date Chaos – Creating a viable date dimension table from any table that you have in the database
No ERD?! No worries! Deriving the output code of a report table from the Information Schema
The Difference Between an INNER JOIN and a CROSS APPLY
Writing messages in spatial data in SQL? Is this possible? Yes! Is it worth it? No
Capture the Flag – SQL Style
Don’t Make DeDuplicating Dastardly Difficult – A devious demystification of the dreaded duplicate
HITMAN: Agent 47 I want you find every available weapon on all of the maps in 5 minutes: JSON query, cross apply and string manipulation
Generating Create Table statements without using the Right-Mouse Button – crazy application of the string_agg function (for no reason)
Exam stress and windowed functions - A devious derivation of the daring use of dense_rank (and other windowed functions) - SQL for no reason
The World of Dynamic Pivoting – in SQL Server
Welcome to The World of Obscure Uses of Code and SQL – First Stop – Solving the Synoptic Gospel Issue with Transact-SQL