Hey JayNir,

If you are a DBA and want to automate jobs, autmate Database Tasks,  if you are working on SSRS you must know T-SQL.  If you know all sysobjects and architecture of SQL Server, it would be great and you will know all of their functionality. If you do not know T-SQL tha i would say you do lack something to be a perfect DBA....For me T-SQL is the most because let us take an example, if you are trying to count the records of  say 500 tables at a time, how you are going to do it? You cannot go to SSMS an right click and see the count or go for each table. In this scenario, you have to write a script, if you wish you can write a Stored procedure.  Also, if you are doing replication, you can set up a job to synchronize the data between two servers( source and target server). Thefore, i rely on T-SQL rather than GUI. We can do everything using T-SQL pertaining Database Admin and Dev also. 

It is just my thought and how i feel about using T-SQL and GUI.

Thanks,