Yahoo TV has an in-depth Q&A with Ronald D. Moore and Brannon Braga, the co-writers of the series finale of "Star Trek: The Next Generation." A couple of the tidbits that I didn't know about:
* the original idea of time-shifting Picard included a fourth time period, which would've been the events of the two part "The Best of Both Worlds," when he was assimilated by the Borg;
* another plot point in the future time period was going to involve having to steal the Enterprise D from its resting place as a museum (an idea that Moore noted was used in his "Battlestar Galactica" reboot).
Also interesting was that they were willing to state publicly that they thought "All Good Things" (the series finale) was better than Star Trek: Generations (aka Star Trek 7). I actually think Generations is kind of underrated, and it's quite fitting that it continues the trend of, whenever Picard turns the Enterprise over to Riker, it gets somehow messed up - totaled, in this case.