Star trail time lapse photos. Set up your camera in a safe and sturdy place and take pics every couple of minutes. Make a composite in Photoshop of Lightroom and you will have your very own star trails! Hope to take some like this once I have a tripod.
Step-by-step Guide to Long Exposure Photography. A Post By: Francesco Gola. http://digital-photography-school.com/step-by-step-guide-to-long-exposure-photography/
An interesting daytime long exposure photography tutorial by Alex Wise that covers the equipment needed for daytime long exposures, examples of how the effect works and a chart to help you calculate your long exposure photographs.
40 Amazing Long Exposure Photos
Photographing Long Exposures of Sparklers (Tutorial)
Deborah Sandidge, Shooting Long Exposures: http://www.nikonusa.com/en/Learn-And-Explore/Article/hcht3dfr/shooting-long-exposures.html