While I still feel Robert Picardo is a bit wooden in his performances so far, he gets a good bit of character development in the subplot regarding his future as the commander of Atlantis.
This was a great way to bring back Kolya, who was an excellent nemesis for Shepard in the first few seasons. The loss of the hand was an intriguing twist in the story, and left me wondering what kind of adjustments Shepard would be going through for the rest of the season. While it was of course "all just a dream"; even after Woolsey's new girl was revealed to be not so real, I did not connect Shepard with having a hallucination until it was revealed.
Overall, an excellent episode that had many clever twists, with solid performances from Picardo and Flanigan.