>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?

I hadn't heard of that before. Looks cool!