I personally like having SoD effects in my campaigns. I also agree with those who say that having a PC die is not a great idea. So, I usually just make sure the PC's have a "way out" of death if it does occur. Either they have the gold and a friendly Cleric who can resurrect them (True Res is the only way to go though as losing a level is often even worse than death and can unbalance the group to boot) or a magic item that can bring them back, or a house rule mechanic like a Fate Point that a PC can spend to "avoid death" and instead just be unconscious at -9 hit points. I also let PC's spend their Fate Points on other PCs and not just themself. This has the effect of keeping the suspence of defeat without having the pains of actual death. Of course, if there are no more Fate Points left in the group someone could still die. I always had the PC reset back to 1 Fate Point at each new level. I had also considered some mechanic that gave them bonus xp if no Fate Point had been spent on them during their previous level, but never got around to implementing it.