-
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 ... -
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 ... -
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 ... -
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 ... -
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 ... -
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 ... -
Add a column with a default and foreign key constraint
Every so often you may be presented with the requirement to add an additional column to one of your database tables. My experience, with SQL ... -
Welcome Baby Katherine
More than fourteen years ago I heard for the first time that I was going to be a father. To a boy. I think dads ... -
Delete rows in Excel from a list
I had the need recently where I was provided an Excel XML file containing a large list of SKU's. From this list I queried a ... -
How to find my full sitepath?
Having trouble finding the full path in your shared web hosting / VPS? <?php echo $_SERVER["DOCUMENT_ROOT"];?> PHP Manual describes it as: The document root directory ...
