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 one row-space, comma seperated. These sorts of problems…
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 something else: will return NULL. Full details here on the…
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 other programs, or in existing batch files. For a number of reasons…
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 cutting to the chase and stealing his thunder: explicitly set the size…
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 (RSJM) application was originally written to monitor long running reports in Microsoft…