We had a thread about this back in '09: http://www.trekbbs.com/showthread.php?t=81578 Although I guess a few names have been added to the memorial wall since then.
Looks like more than a few... and some names will need to be taken off of that list. If I get some time IRL (of which I had quite a bit of recently because of the Thanksgiving holiday), I think I will try to do some updating work on that list myself. Unless, of course, someone else would rather do it themselves.
Q Junior (The Eternal Tide) Amanda Q (The Enternal Tide) Kathryn Janeway in every single other universe but this one (The Eternal Tide) The Deep Space Nine station (Plagues of Night) Noonien Soong (Peristence of Memory) And if living with the Wormhole Aliens counts... Kira Nerys (Raise the Dawn)
^Not sure Soong counts, because he was already presumed dead in canon anyway. So he was both un-killed and then killed later in the same book, which more or less cancels out.
Scotty's more of a cliffhanger- we don't actually know for sure, all we know is that the other characters were convinced he's dead
Do Mirror Universe counterparts of canon counterparts count? Because Mirror Kira*, Worf*, Kassidy Yates, Cal Hudson, Zek, Riker, Tasha Yar, Elizabeth Shelby, Klag, Martok, Kes, Janeway, Seven of Nine, Chakotay, and Leeta* are dead (at the very least). *These people showed up in actual episodes, so they are canon either way.
How do we define canon characters? Extras who barely showed up and had names only in the script count?
Any character who originated in TV/film Trek. Although, when I think of Selar or a few others, it's their role in the novels that comes to mind, not the TV episodes.
In a book written by Krad - now in exile from writing star trek lit. If bringing the character back is in the least advantageous for some future plot, he will be brought back - and 'Articles of the federation' will go the 'didn't happen in universe' route of 'Indistinguishable from magic'.