Just been catching up on the PDC presentations, came across this one on Yukon, also, for an interesting perspective on why you should use SPs in Sql Server, watch the first 10 minutes! Man, I am so looking foward to Yukon reaching RTM; the architectures which this thing enables will be so elegant.
UPDATE: As Jon Galloway pointed out, these are pretty buggy; the UI takes a bit of getting used to (or sucks to an incredible degree would be more accurate) - hint, don't click on the images for each track, click on the text. Worth persevering though!