Some of my Favourite Podcast Episodes
Some of my favourite podcasts from the last 4 or 5 years of listening.…
Read MoreCrunchie bar cheesecake base (for dummies)
I'm not one for posting recipes (nor, for that matter cooking, baking or much other kitchen activity), but since Google search results for 'Crunchie bar cheesecake base' don't come back with anything obvious or decent, I thought I'd whack this on here. I'm a member of a Cheesecake Tuesday club…
Read MoreVisual Studio build error: Unable to delete file obj dll warning MSB3061
Getting the error Unable to delete file obj dll warning MSB3061 when trying to build in VS2015 has driven me round the twist on a number of occasions. I generally go through all the obj and bin folders of each of my projects deleting DLLs, and eventually it seems to…
Read MoreHandy SQL: Counts Across a Date Range
I recently wanted to list a count of occurrences across a data range so that I could render a line graph. I knew that some of the dates would contain 0 occurrences, so I knew I'd need to list all dates within the range, and left join to the occurrence-by-date…
Read MoreHandy Winamp title formula
Despite Winamp's fall from grace and lack of continuing updates, many of us still remember the audio player that always has and always will 'whip the lamas ass'. It's still my player of choice, and this is the formula I've used for years to display song titles: [$if2(%albumartist%,%artist%…
Read MoreHow to track down log4net problems
This has driven me crazy on a number of occasions, so I'm linking this here to hopefully save myself and / or someone else the pain I've been through. Credit to David Espart for his Stack Overflow answer on how to track down log4net problems ( http://stackoverflow.com/a/756241/3264286…
Read MoreSetup Visual Studio Team Foundation Server to use WinMerge
I've made this change on a number of occasions, so I'm linking this here to hopefully save myself and / or someone else some time in setting this up. Credit to Paul Bouwer for his blog post Replace diff/merge tool in Visual Studio Team System with WinMerge ( https://blog.paulbouwer.…
Read MoreOur Awesome Music Club
Back in 2012 while at a gig in Bar Bodega, Wellington, me and a friend-of-a-friend were discussing our our various music tastes. Back and forth we listed styles and bands we'd enjoyed our entire lives or recently stumbled upon. Now, 4 years and 20+ meetings later, our Music Club is…
Read MoreSQL Server - Refresh Local Cache to update IntelliSense
If you find your IntelliSense not keeping up with your schema changes in SSMS, try clicking anywhere in your Query Editor window and going to: Edit -> IntelliSense -> Refresh Local Cache…
Read More