Get as close as possible! lol
For inside gigs it is really hard if they have lighting and smoke effects. If they have a press pit see if they will let you in there, usually only for a couple of songs though.
I have always used my Olympus 2mega pixel camera for these. Bit hit and miss though for me.