Stargate Atlantis S03 E08 McKay and Mrs. Miller

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

Rodney McKay is reunited with his estranged sister back on Earth, who has given up a brilliant career as a scientist to raise a family.