A ten minute excerpt from the web demo a couple of days ago. Stephen Wolfram shows some examples of the soon to be released Wolfram Alpha.
As a random addition: I'm now taking an RSS feed of Lifehacker which has passed through Yahoo Pipes and removes a lot of the posts that I'm uninterested in. Can easily be altered to suit your own tastes. My personal feed is a little different from the one posted here. This just takes some trivial tinkering.