Depends on what your looking for! Good food and a a chance to met some people Probably the bar at Barcelona...the later the better in terms of the socializing.

Where are the fireball shots, Darts and sports at? Probably brickhouse or Bradfords. Tigin is much more classic irsh pub quiet. In General you could just walk down Bedford street and find the place that fits your vibe. There is some decent food here too...Fish...Mecca Noodle etc.

The Wheel is probably the best new restaurant, its on the expensive side and your probably not making new friends there but it's a good vibe and great food.

Harbor point is the recently developed part of town. There are some decent restaurants like Fortuna and a couple spots like sign of the whale have a more clubish atmosphere after dinner. There is nice little water front park down there that is nice for a walk and sunset...plenty of people walking dogs to strike up conversations with.

Colony Pizza is top tier bar pizza (like on most of the country wide best pizza lists ) and their bar is great little dive spot to hang out and watch some baseball.

In general Stamford is spread out into different neighborhoods...each has it's own little local spots. For example I swear by Vinnie's Backyard as my local dive n wings and sports but my buddies will tell you Fiddlers green is the spot for that kind of hang.