Following are two pictures taken at the Vancouver Aquarium, both taken with my Canon Digital Rebel. No alterations were made to either picture except to reduce the size.
The fish were shot at ISO 400, no flash, 1.3 second exposure at f/2.8 with a 24 mm focal length. Basically I held the camera up to the fish tank and turned on the auto timer. By doing this, I minimized any jitter and ended up with a pretty interesting picture.
The picture of the giant cockroach was produced in a similar fashion. There was a bit more light so the camara was set to ISO 100, no flash, 1 second exposure at f/4.5 with a 98 mm focal length. Obviously I zoomed in a bit to get this shot.