Liam Talbot

Liam Talbot



13 posts follow

IT

Handy 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 new I'd need to list all dates within the range, and left join to the occurrence-by-date…

Read More

Music

Handy 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 More

IT

How 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 More

Setup Visual Studio 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 More

Music

Our 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 More

Beer

First Attempt at Brewing - Ale'y Porter and Mexican Honey!

Having been gifted a beer making kit earlier this year, myself and some friends recently ventured into brewing our first batch. As it turned out, one accomplice, Matt, had his own kit too, so we decided to join forces and produce 30 litres each of two beers. So we have…

Read More

IT

TFS - files not showing under source control in Visual Studio

While using the Visual Studio 2010, 2012 or 2015 Solution Explorer pane, I've noticed after getting latest from source control (in my case TFS) new files retrieved are missing the lock indicator. I'm not sure it makes any difference to the project, the build or your pending changeset, but it…

Read More

Travel, Photography

Helicopter Ride Around Wellington

For my 34th birthday this year, my wonderful girlfriend got me a helicopter flight around Wellington city. It was a truly memorable and beautiful experience, and I must compliment Wellington Helicopters who have recently taken over the waterfront operation for offering an excellent tour throughout.…

Read More

Beer

Beervana 2015

I've been living in Wellington 6 years and 3 months now, and this was my fourth visit to New Zealand's premier beer showcase and appreciation event, Beervana. This year it was back in the regional sports stadium, locally known the 'Cake Tin', as it was twice before when I attended.…

Read More