I just finished my rewatch of Stargate Atlantis and got to see one of my favorite Stargate episodes, Brain Storm. In it Rodney McKay gets invited to a science presentation by an old rival of his, Tunney (Dave Foley), where he is the target of some derision since it is hard to publish research papers when you are doing top secret alien related research in another galaxy. Bill Nye and Neil deGrasse Tyson show up and Nye actual plays a fairly decent sized role in the episode.
It is a fun episode and for the most part stand alone so worth checking out. Here is a behind the scenes featurette and a couple of scenes.
Note: I have never met Bill Nye but he doesn't seem like he is actually a jerk.