-
Liam turns 12
Liam is 12 today, forever sharing the day with Little Nan, who would be 113 or 114 today? There or thereabouts. It is hard to believe it has been just ... -
SSRS - Hide textbox if no data
Within SQL Server Reporting Services 2008, hiding a tablix is simple when there are no rows in the dataset. Simply add this expression to the tablix Visibility: However, I had ... -
SSRS - Force Proper Case
Ever had to deal with someone who likes to store their title content in ALL CAPS... thereby mucking with your report formatting and general nonsense? This little ditty can be ... -
Alex Tobin Wins ASA Award feat. Frenchy in Music Video
You meet all sorts of people playing cricket over the years. One of the more fascinating ones? Alex Tobinโa bloke I first crossed paths with on the pitch and later ... -
Update value from SUM(values) in another table
I recently found myself forgetting the exact syntax to update a value in a table based on the sum of another set of values in another. You cannot, for example, ... -
Nevan turns 14
It's weird seeing it in writing... 14 years old... my god... For this young man's birthday we gathered a few of his mates and head to Hangtime Trampoline Park for ... -
Family Abseiling Adventure at Mt Keira, Wollongong
We recently spent a spectacular day abseiling at Mt Keira in Wollongongโan unforgettable experience made even more special thanks to my longtime mate from high school, Shane Murphy, whoโs a ... -
Find text in Stored Procedures
I can't express how useful this has been to me when trying to find whether a text string exists in one of our Stored Procedures / Functions: -
Most Active Databases in SQL Server
I recently had someone ask what the most active databases were in our SQL Server. Well... we knew which was the most active (based on our application) but there were ...
