Both drill/ceremonial and actual shooting with live rounds including competition shooting.
This is the one I was thinking of.
I often find keeping yourself cool in general can reduce sweating, particularly my feet. I don't get sweaty hands but I find if I keep my feet cooler than I'm cooler all over in general.
If you are wearing boots then make sure they aren't too tight and wear some cotton socks if possible. You can get cooling gel pads or foot sprays or similar and anti sweat powders to help as well. I find the gels lovely, I have one from Boots or use cooling Aloe Vera gel (you can keep in the fridge to make even cooler), or peppermint spray, BodyShop had a lovely one. You could even try the peppermint spray on your hands, if nothing else they'd smell nice!