-
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 ... -
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 ... -
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 Server 2008 and above at ... -
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 secretly long to hear those ... -
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 SQL database to figure out ... -
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 under which the current script ... -
2012-13 - That Tied Illawarra 2nd Grade Grand Final
Undoubtedly the rivalry of the season in 2nd Grade were the clashes between the Northern Districts Butchers and the Wollongong Lighthouse Keepers. Not only did they finish just 2-points apart ... -
Hide SSRS Toolbar
If you'd like to hide the Report Viewer toolbar whilst utilising ReportServer, you can simply append the following to the end of the query string: &rc:Toolbar=false Which may end up ...
