I took my Panasonic DMC-G1 camera, set it on the widest setting, focused on something lit up in the distance, set it on manual, maximal aperture, 14mm F/3.5 setting on the 14-45mm lens, 30 second exposure, and put it upside down a table on our balcony. I was surprised how much more you see than with the naked eye. Here's the result (with the slightest bit of editing to crop and to darken the sky).
That's Lyra at the bottom and Hercules in the middle. If you look really closely, you should be able to see M13:
At 30 seconds, even at this low, low magnification, star trails start.
And here's the Baylor Science Building with Venus setting over it: