WO2 Ian Fisher leaves his wife, Emma, two sons, James, seven, and William, five, and his parents, Simon and Helen.
Paying tribute, Emma said: "Ian will always be the centre of my life, he will be remembered as a doting father, loving husband and a true professional soldier.
"He loved being a soldier, that's what he lived for. We are all so proud and always will be."
The MoD said WO2 Fisher's colleagues described him as "the epitome of an Infantry Sergeant Major, straight talking and obsessive in his pursuit of excellence and gaining the most from his subordinates while ensuring their wellbeing."
More top news
ITV News Political Editor Robert Peston has travelled to Yorkshire to find out the views of voters in an area which voted to leave the EU.
Heavy rain - mostly across Wales - will clear eastwards throughout the day tomorrow
A former coach and kit man at Scottish football clubs has been charged with sexual activity with a child.