A British soldier who stabbed his girlfriend to death in a "frenzied" attack as their children slept upstairs has been jailed for life, police said.