The Star Gazer

Retired admiral Jean-Luc Picard rejects the romantic advances of his housekeeper Laris, a year-and-a-half after the death of her partner Zhaban. After giving a speech to a new class of cadets—including his former ward Elnor—in his role as chancellor of Starfleet Academy, Picard visits his old friend and bartender Guinan to talk about his life-long avoidance of romantic relationships. In deep space, Captain Chris Rios and Dr. Agnes Jurati of the USS Stargazer investigate an anomaly that broadcasts a request to negotiate entry into the Federation with Picard. They are joined by Seven of Nine, a vigilante flying Rios's old ship La Sirena, and a fleet of starships including the USS Excelsior which has Elnor and Picard's old first officer Raffi Musiker on board. When Picard arrives, a Borg ship emerges from the anomaly and transports their Queen onto the Stargazer.

Summary from Wikipedia, CC BY-SA 4.0.