It looks like you have multiple hats. The tools you need depends on the tasks you do. SSMS (and that implies SQLCMD and BCP etc) is a must. If you are into scripting/coding, a good text editor will make your life easier. Within my collections, Adam Machanic's sp_WhoisActive and Glenn Berry's SQL Server Diagnostic query sets are my top favorites.