At this current position we use SSMS mostly, though some of the developers use SQuirreL for query design etc.. The application itself is written in java using hibernate.