SQL Server: converting rows to lists with & without Coalesce
Today I had a data layout issue to solve for a Reporting Services report I was writing. The report had to aggregate data from another table, but lay out the values into...
Read MoreSQL Server Tip: NULLIF
To my shame, I’d never come across this in-built SQL Server function unless today. The NULLIF function allows you to specify a NULL if the result was going to be...
Read MoreNAnt task – bat file error codes
Just a quick something I found out a couple of moments ago. The <exec> task in NAnt is a life-saver for gluing together functionality that’s locked up in...
Read MoreSlow loading site? Set your image sizes for an easy win!
This is a brilliant and simple tip Rob picked up today whilst working on increasing page load times. I’ll leave him to explain all the details whilst deftly...
Read MoreReporting Services Job Monitor
I’ve just posted the source code to an application I wrote 2½ years ago, whilst at the same time started using it again. The Reporting Services Job Monitor...
Read MoreWordPress on 1and1 – 500 errors etc
If you’re using WordPress on 1and1.co.uk then you may find that WordPress isn’t quite as fluid as you’d been promised. Random 500 errors, plugins not...
Read More