top of page
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
Anybody who knows me know that I am a HITMAN enthusiast. I love that the fact that it is a cerebral game. Sneaking around, trying to...
Jun 8, 20241 min read
Generating Create Table statements without using the Right-Mouse Button – crazy application of the string_agg function (for no reason)
Your manager walks in and says to you, I need you to create a shell of all tables that reside in our Microsoft SQL Server by lunchtime....
Jun 6, 20241 min read
Exam stress and windowed functions - A devious derivation of the daring use of dense_rank (and other windowed functions) - SQL for no reason
As you walk into the exam room, the hp envy is ominously sitting there, waiting to be programmed. You know you’re in for a doozy of a...
Jun 4, 20242 min read
The World of Dynamic Pivoting – in SQL Server
Times are changing, databases are getting more sophisticated and there are in-built functions that previous DBAs had to solve for...
Jun 3, 20242 min read
Welcome to The World of Obscure Uses of Code and SQL – First Stop – Solving the Synoptic Gospel Issue with Transact-SQL
Today we are looking to solve the problem of the synoptic gospels with SQL. Is this possible? Will we get anywhere? Probably not. But...
Jun 3, 20242 min read
bottom of page