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

T-SQL is SQL Server built-in programming language.