Star Trek X!!!

He was a guy who was in some episode in TNG series with a smal role! You know, one of does smal roles where you know his name and he takes part in some adventures but dont have a leading role! (Like that Vulcon guy in Voyager who works in Engenering)
He was turned in to a borg and Picard shot him out in to space!
I realy liked his character and was sad to se him die!