Care to talk about depleted uranium?

A band that I listen to has a really cool song about depleted uranium. I just wanted to get some more information about it.

What is it? Where does it come from? Why is it so harmful? Is this deja vu from Agent Orange in vietnam?