Stargate Atlantis S05 E16 Brain Storm

"A new gate will open. A lost city will rise again."

Dr. Rodney McKay reluctantly returns to Earth to witness the triumph of his rival Dr. Malcolm Tunney, but must help shut down a deadly weather device when the new technology goes horribly awry.