It is low level cursing, it means someone who is uncooperative, mischievous, grumpy or a pain in the rear. Sod is similar to git. It's only slightly rude.

JYD #3 Poor, but still dreaming of a sage and black SOD CG...