I just noticed an interesting thing about the schema rowsets when queried using the new DMV syntax and that is that you can drill into hierarchical data - cool.

This probably comes out of building the DMV syntax on top of DMX which seems to make a bit of use of nested tables.