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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 A good tool for DBA

Author  Topic 

CanadaDBA

583 Posts

Posted - 2005-10-04 : 09:20:25
There are lots of tools for SQL Server available in the market. What is a good one for a DBA to purchase? Why? Are you using it in your environment?

Canada DBA

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2005-10-04 : 09:57:41
quote:
Originally posted by farhadr

There are lots of tools for SQL Server available in the market. What is a good one for a DBA to purchase? Why? Are you using it in your environment?

Canada DBA



I think it really depends on what your needs are. I personally deal alot with DB versions and development type administration. I find myself using the Red Gate tools quite a bit (SQL Compare).

________________________________________________

Working man's privilege, beer is.
Harsh, Life is.


Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-10-04 : 12:59:05
Two of the best tools for a DBA to master are BOL (SQL Server Books Online) and Query Analyzer. Once these have been fully mastered, a DBA is nearly unstoppable. And best of all, they're FREE!

---------------------------
EmeraldCityDomains.com
Go to Top of Page

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2005-10-04 : 15:51:13
Yip another two worth mentioning (also free) mdsn and sqlteam.com

Duane.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-10-05 : 01:23:14
FWIW Query Analyzer and Enterprise Manager are all we use.

Kristen
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-05 : 01:48:20
I wonder what other tools do that EM and QA dont do

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2005-10-05 : 03:22:13
Log Explorer from Lumigent (www.lumigent.com) is a very good tool for transaction analysis and data recovery solution.
With it you can manage and understand the transaction log and of course resolve some database problems.
You can identify source of data change and recover from modified,deleted,dropped or truncated data,receive notification via email for a lot of database related events,undo single operation or multiple transactions, recover an entire table (dropped or truncated)and more.



Franco
Go to Top of Page

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2005-10-05 : 07:06:02
I use Log Explorer too, and the Red Gate tools. I don't use them that often but in my opinion they have more than paid for themselves


steve

-----------

Facts are meaningless. You could use facts to prove anything that's even remotely true!
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-10-05 : 07:06:35
EM and QA can't re-create dml and ddl scripts from log files unlike log reader programs

though a good DBA will not need one

quote:
Originally posted by madhivanan

I wonder what other tools do that EM and QA dont do

Madhivanan

Failing to plan is Planning to fail



--------------------
keeping it simple...
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-10-05 : 07:17:27
Not needed a Log Reader so far - our application logs what it needs to in order to enable debugging of live sites.

Kristen
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-05 : 07:42:51
>>though a good DBA will not need one

I hope you dont need that

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-10-05 : 09:51:32
i actually used once, but learned my lessons

DBA101, backup and restore



quote:
Originally posted by madhivanan

>>though a good DBA will not need one

I hope you dont need that

Madhivanan

Failing to plan is Planning to fail



--------------------
keeping it simple...
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-10-05 : 09:55:52
Where's Jon?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-10-05 : 10:32:04
quote:
Originally posted by X002548

Where's Jon?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx



Now he is here
http://sqlteam.com/forums/topic.asp?TOPIC_ID=56087

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

mramir74
Starting Member

3 Posts

Posted - 2005-10-05 : 16:40:14
Another cool tool and it's FREE.

http://www.idera.com/Products/SQLcheck/Default.aspx

Go to Top of Page

bakerjon
Posting Yak Master

145 Posts

Posted - 2005-10-05 : 18:41:43
Another really great tool if you have the fundage is Quest Spotlight.
http://www.quest.com/sql_server/

If you are designing databases I think Embarcadero ER/Studio is tops!

I believe SQLMag did a piece recently on top software by category. You might want to try that site to see if they have something you could use.

Now I know, and knowing is half the battle!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=48013

Go to Top of Page
   

- Advertisement -