Welcome aboard Pauly. Nice to have some more West Coasters around here - Roger usually has to give us some perspective on the Land as most of us frequent the World more often. I lived in Cali when I was 3-7 years old,and again from age 21-25...I last was over there in 1994, so there's been alot going on at Disneyland I would love to see someday if I can get back over there.
Enjoy the night shooting - it's great fun, and your camera should be great at it. My only addition to Roger's advice is to stick to the lowest ISO setting - if you've got the tripod and are taking long exposures anyway, might as well keep the noise down and let the sensor absorb all the light it needs to expose the shot.
If you're feeling more brave on manual controls - sometimes just starting with a 'middle' aperture somewhere between F4-F6.3 on a compact like yours, then experimenting with varying shutter speeds to get the exposure you want, can be pretty easy. As you get to know your camera, you can determine when bigger or smaller apertures are appropriate.
Looking forward to seeing your shots around here!