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 30
- 1 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 21
- 1 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 18
- 1 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 13
- 2 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 11
- 1 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 8
- 1 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 6
- 1 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 4
- 2 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 3
- 2 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 3
- 2 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