Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: What's best for DBAs? GUI or T-SQL commands?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-04 : 11:46:20
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!"

Article Link.

nr
SQLTeam MVY

12543 Posts

Posted - 2002-09-04 : 13:15:43
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.
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-09-04 : 19:20:26
quote:

What's best for DBAs? GUI or T-SQL commands?



Why do IT people have to be so one sided ?

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.

Damian
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-09-04 : 21:45:31
quote:

Why do IT people have to be so one sided ?

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.

Edited by - ajarnmark on 09/04/2002 21:47:39
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-09-04 : 22:09:14
Oooppps, I pulled an NR and commented before reading it

Damian

Edited by - Merkin on 09/04/2002 22:11:02
Go to Top of Page
   

- Advertisement -