This technique involves using a tripod and shooting two exposures from the exact same place, with the same aperture, but with two different exposures, and more importantly, at two different times of night. The first shot, I'd recommend you shoot at dusk or twilight so that you get a little of the light from the sky (here it is a little light from the overhead ceiling light). This shot can be a little darker than normal (under exposed).
Then, leave your camera set up exactly as it is (in a safe place), have dinner, or do something else for a few hours, and then shoot another photograph from the same place. In this second photograph, make sure that there are now artificial lights on that were not on before, such as street lights, security lights, interior lights, etc. For this exposure, let it be very dark overall, but with good brightness in the actual lights themselves.
Finally, we'll combine the two images together to form a much more interesting night image. You'll put the second image on a layer above the first image, and change its blending mode to "lighten".
I might recommend using both a tripod for this, and using either the self timer built into most cameras, or an electronic shutter release which can allow you to trip the shutter without touching the camera. These seem to come in both cable, and wireless versions.
Composition your Two images