Trivia: This is the first episodes where the "dress" Starfleet uniforms are worn. They had a long gold braid which was the entire length of the jacket.
When LaForge and Crusher help Worf up off the floor in Sensor Maintainence, you can see the label for the door that should normally be outside in the hall.
When Singh falls and dies, his eyes are wide open, but when Worf rolls him over and says he is dead, they are closed.
Trivia: In Star Trek VI: The Undiscovered Country, Spock refers to Sherlock Holmes when he says the line "An ancestor of mine maintained that if you eliminate the impossible, whatever remains, however improbable, must be the truth." Data used the same quote in this episode, although not with the exact same words: "We must fall back on the old axiom that when other contingencies fail, whatever remains, however improbable, must be the truth."
In the final scene, Picard, Riker, and Troi treat the death of a peace delegate with a lightness and sense of humor that is completely innappropriate and out-of-character. I mean, wouldn't this mean war between two species wishing to join the Federation? Isn't this the murder of a sentient being?
As the Enterprise returns to the energy cloud, in an undershot of the ship, you can see the NCC-1701-D reversed.
Riker: (getting snared) What the hell?
Antican Candidate: Sssorry, wrong ssspecies!
Dr. Crusher: You are only an Acting Ensign, Wes. You have to let the commissioned officers do some of the work.
Picard: What are you talking about Data? Is this still Sherlock Holmes?
Data: Indubitably, sir. Indubitably.
Picard: Well at least you got rid of that damn pipe.
Data: Elementary, my dear Riker.....sir.
Riker: We no longer enslave animals for food purposes.
Antican: But we have seen humans eat meat.
Riker: You've seen something as fresh and tasty as meat, but inorganically materialized out of patterns used by our transporters.
Worf: You wanted me, Doctor?
Dr. Crusher: Yes, concerning your memory blackout.
Worf: (peeved) I still don't remember having one.
O'Brien's uniform is now gold, the color it will remain throughout TNG and DS9. He appears in red in "All Good Things..." only because Picard has gone back in time to the first episode when O'Brien wore a red uniform.
It indicates here that the character of Miles O'Brien is not formally introduced until Season 2's "Measure of a Man." However, a few episodes before that one, in "Unnatural Selection," when Riker calls him in the transporter room he answers back and refers to himself as "Chief O'Brien."
Singh had the dubious honor of being the first Enterprise-D crewman killed on the series.
Marc Alaimo, better known for his role in Star Trek: Deep Space Nine as the infamous Gul Dukat, makes a guest appearance in the episode as the Antican Delegate.
Picard: Time and tide, Lt. LaForge.
Referencing the old proverb, the modern variation of which is "Time and tide wait for no man". Robert Burns, in Tam O'Shanter, (1787) put it, "Nae man can tether time or tide". Robert Green, in Disputations (1592) wrote "Time nor tide tarrieth no man".
Data: Indubitably, my good woman.
Data takes on the mannerisms of Sherlock Holmes, a fictional Victorian detective created by Sir Arthur Conan Doyle. Data's fascination culminates in later episodes with holodeck adventures and the self-conscious holodeck character Moriarty.