If you haven't made a decision yet, you might want to look at the free version of LinQPad.

http://www.linqpad.net/


>Is TSQL still in used to allow superusers to do queries as they see fit in the database or there is something better now? Other than SSMS, which is a component installed during SQL Server installation, I do not think I have seen any other utilities to do such. So, I assume TSQL is something which is downloaded separately. Is this the case?