What do you folk do with your White Balance settings for the night shots like the one on the TTA for example?
Best way to deal with white balance until you get the hang of it, is to just look at it! Take a shot, see how it comes out (or view it on the LCD in a live-view based camera). Look too red? Too blue? Change the settings, and try again. Auto White Balance often works, but can be confused by manmade lighting at night...and some AWB systems need a half-press of the shutter to 'check out' the lighting, and make an adjustment - so if you just press the shutter right away, you get more errors from AWB than if you half-press and delay a bit to let the system adjust itself. When shooting around flourescent or sodium vapor night lighting, often a 'tungsten' or 'incandescent' white balance setting will deliver a nice look at night...so you can try those. Or if your camera has a manual white balance setting mode, try finding something white to point the camera at, and run the manual adjustment.
Remember too that 'correct' white balance isn't always the best white balance...some photographers get all involved with trying to get everything to be technically perfect - but white balance being overly warm or overly cool might actually help deliver just the 'look' you want, or a better memory of how the scene looked to the eye. Main Street can be a good example - if you stand there and look at it, the lights of Main Street look a bit yellowish, which lend it a classic look...but if you were to take a photo and adjust the white balance to be 'technically' correct, the lights would be perfectly white - losing the yellow glow that most people's eyes actually perceive. So if you wanted to catch Main Street in the way it actually looked, and were looking for that warmer yellowish lighting, 'correct' white balance would eliminate it and give you a colder, more clinical look.
For me, white balance isn't always about a technical measurement, but about the feel or atmosphere of the scene and how I want to capture it. So I sometimes let my white balance be a little overly warm, or cool. In the TTA shot, it's on Incandescent, and still leans a bit towards warm - which I liked for those colored lights streaking. Let white balance be what you want it to be - pay attention to it for sure, and understand it, but don't always try to make it a technical or scientific measurement of what's right. Think about what makes sunset such a gorgeous time of day - everything takes on a warm, orange-yellow glow...white things don't look white, they look yellow/orange. If you were to take a 'corrected white balance' sunset shot, it wouldn't look like a sunset anymore!