Man, I hate these threads. Though I'm glad that you shared it with us. I opened it hoping that it was a human that died, preferably a really old one that lived the schit out of life.
Schnauzers are amongst the cutest and best personality dogs on earth. It says a lot about you that you picked that breed, all dogs are generally great but there are subtle clues about the owner depending on breed, IMO.
He can join my giant rabbit, Romeo, in dog heaven if there is such a place. I feel your pain, buddy.