The new IntelliSense in SQL Server 2008 is fantastic, and makes SQL development and maintenance much easier. However, sometimes it can be annoying, as changes and additions are not always immediately reflected in the IntelliSense. I recently got told about…
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…