Why Does Asparagus Make Your Pee Smell Funny?

Here's what gives "asparagus pee" that sulfurous smell and why some people just can't detect the odor.