A useful article, but I think you leap to the CROSS APPLY example with nodes a little early. I only understood this having first seen an example elsewhere that used...

A useful follow-up to this would be some code to consume and re-output a data flow - this would be a verycommon task, and is a little fiddly to understand

I've seen this construct used many times, and typically it is a little poor on performance. An index on First and / or Last Name will usually be used, for...

I've installed SQL2005 as a named instance alongside SQL2000. There appear to be some issues with the 2005 installation, for instance I am having trouble connecting to Analysis Services on SQL2005....