Narayana Vyas Kondreddi submitted "This article discusses the advantages and disadvantages of using the SQL Server graphical administration tools (Enterprise Manager) versus the T-SQL administrative commands, with specific examples. Read up and decide for yourslef, if you want to be a point-and-click DBA or a T-SQL scripting expert!"
Haven't read the above but using the gui doesn't allow you to save a record of what you have done so never use it for updates. Maybe for creating databases but I don't even do that.
For enquiries - maybe it is ok now - 6.5 it used to take locks so was pretty damaging to a production system. I use it for seeing if scheduled tasks are scheduled/running sometimes but that's about it. Sends a lot of data so not so good over a slow remote connection.
Do almost everything in a query window and if you are just looking at a production system make sure you execute set transaction isolation level read uncommitted first.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
I think the answer to the question of tools is "both". Use both, depending on what is most efficient for the task at hand.
Just because one thing is good does not make something else bad.
Isn't that essentially what VyasKn has said in the article?
I agree. And I like this article because it points out some of the strengths of EM and also some of its weaknesses. Seems pretty well-balanced writing.
Article: What's best for DBAs? GUI or T-SQL commands?
Posted - 09/04/2002 : 11:46:20
