Im more of voyager guy. But TNG is started to grow on me. Only watched the the series once, so its up for round two soon.
Yeah, he just smacked my bum and stuck it in (sounds so wrong haha). It minimized the pain. I think it varies though. Sometimes I dont even feel my shot, and sometimes it stings. I noticed that if I have too much coffee I am more sensitive to the pain. I would say there is nothing wrong with having a glass of wine before your shot. Assuming the person is healthy enough and has no issues with alchohol.