Date Chaos – Creating a viable date dimension table from any table that you have in the database
Would you like to know how many Tuesdays are in 2024 and 2025 using a random table from the Adventureworks Database? No? Me neither. But...
top of page
Jun 301 min
No ERD?! No worries! Deriving the output code of a report table from the Information Schema
We’ve all been there. You turn up to work and your manager says you need to generate some reports from so-and-sos database. Cool, no...
Jun 211 min
The Difference Between an INNER JOIN and a CROSS APPLY
Friday night football, Wests Tigers are in front and your wife reminds you that you are going to see the in-laws. Sometimes it’s...
Jun 181 min
Writing messages in spatial data in SQL? Is this possible? Yes! Is it worth it? No
Are you sick of writing cards for your spouse on a special occasion? Would you like to do something a little more meaningful? If you...
Jun 142 min
Capture the Flag – SQL Style
Capture the Flag is native to the area of cybersecurity. The thrill of writing the correct linux command to retrieve the password in CTF...
Jun 111 min
Don’t Make DeDuplicating Dastardly Difficult – A devious demystification of the dreaded duplicate
Hey Lucas, Yes boss? Can you tell me which tables have duplicates in the Sales schema in the Adventures Works database by lunchtime? But...
Jun 81 min
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 61 min
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 42 min
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 32 min
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 32 min
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...
bottom of page