Star Trek: The Next Generation - 4x19 - The Nth Degree

    While looking at a malfunctioning scientific array, Lt. Barclay gets zapped by a strange probe.  From there on, he becomes much more confident, and much more intelligent.  Then he links himself into the ship's computer.
    I like this episode a lot.  I've watched it several times, and even though some of the campiness of the script comes out, it plays wonderfully.  Much of the success of the episode has to do with how enjoyable Barclay-centric episodes are.  He doesn't show up often, but he's a wonderfully flawed character.  He's a perfect stand-in for the stereotypical dateless Trekkie.
    Barclay actually makes Troi a useful character as well.