Is this possible on a conon powershot SD1100 IS?
If it has a TV or M setting then yes. If no manual setting, no.

According to DPReview the SD1100 has a Manual mode.
To achieve a similar effect you will need to use a tripod, set the smallest possible aperture (the highest f no, I think that my Fuji went up to f32 from memory), the longest exposure (15s on my Fuji), and the self timer so that you don't bounce the tripod.
Aim the camera and tripod at the subject, focus, and start the self timer.
Focus on the airport shot linked above should have been easy enough due to the amount of light for the focus to fix on, if your subject is too dark then you can manually focus if your compact allows it, but it was a pig to get right with my fuji.
Steve