Stargate Atlantis S03 E14 Tao of Rodney

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

After an Ancient device gives Rodney superhuman powers, his enhanced brilliance is checked only by his impending death -- unless he can learn how to ascend.