SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 A good tool for DBA
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

CanadaDBA
Aged Yak Warrior

Canada
583 Posts

Posted - 10/04/2005 :  09:20:25  Show Profile  Reply with Quote
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

USA
298 Posts

Posted - 10/04/2005 :  09:57:41  Show Profile  Reply with Quote
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

USA
3246 Posts

Posted - 10/04/2005 :  12:59:05  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

South Africa
1466 Posts

Posted - 10/04/2005 :  15:51:13  Show Profile  Visit ditch's Homepage  Reply with Quote
Yip another two worth mentioning (also free) mdsn and sqlteam.com

Duane.
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 10/05/2005 :  01:23:14  Show Profile  Reply with Quote
FWIW Query Analyzer and Enterprise Manager are all we use.

Kristen
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22760 Posts

Posted - 10/05/2005 :  01:48:20  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
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

Switzerland
255 Posts

Posted - 10/05/2005 :  03:22:13  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2050 Posts

Posted - 10/05/2005 :  07:06:02  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 10/05/2005 :  07:06:35  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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

United Kingdom
22403 Posts

Posted - 10/05/2005 :  07:17:27  Show Profile  Reply with Quote
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

India
22760 Posts

Posted - 10/05/2005 :  07:42:51  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
>>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
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 10/05/2005 :  09:51:32  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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 - 10/05/2005 :  09:55:52  Show Profile  Reply with Quote
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

India
22760 Posts

Posted - 10/05/2005 :  10:32:04  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
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

USA
3 Posts

Posted - 10/05/2005 :  16:40:14  Show Profile  Reply with Quote
Another cool tool and it's FREE.

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

Go to Top of Page

bakerjon
Posting Yak Master

USA
145 Posts

Posted - 10/05/2005 :  18:41:43  Show Profile  Visit bakerjon's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000