Watch this same video in HD (Silverlight required) on the Microsoft website

It should be stated that Adam is actually using two applications, Windows Live Photo Gallery and Windows Movie Maker which comes with Vista.  Eventually, Windows Live Movie Maker will come bundled with Live Photo Gallery but its just not ready yet.