The most recent sci-fi production I have been involved with, is "Stargate Universe". My role was to build (model/texture) the main spaceship for the show called the "Destiny". The Destiny is an Ancient ship, where the main cast is stranded upon. The ship hasn't been revealed yet, but here's a 45 second promo video from Scifi.com that gives you a taste of what's to come. The show will premiere on Friday, October 2 in the US.
Video after the Jump