| Author |
 Topic  |
|
|
CanadaDBA
Aged Yak Warrior
Canada
583 Posts |
 Posted - 10/04/2005 : 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
USA
298 Posts |
Posted - 10/04/2005 : 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.
|
 |
|
|
AjarnMark
SQL Slashing Gunting Master
USA
3246 Posts |
Posted - 10/04/2005 : 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 |
|
|
|
ditch
Flowing Fount of Yak Knowledge
South Africa
1433 Posts |
Posted - 10/04/2005 : 15:51:13
|
Yip another two worth mentioning (also free) mdsn and sqlteam.com 
Duane.  |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 10/05/2005 : 01:23:14
|
FWIW Query Analyzer and Enterprise Manager are all we use.
Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
India
22469 Posts |
Posted - 10/05/2005 : 01:48:20
|
I wonder what other tools do that EM and QA dont do
Madhivanan
Failing to plan is Planning to fail |
|
|
|
franco
Constraint Violating Yak Guru
Switzerland
254 Posts |
Posted - 10/05/2005 : 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 |
|
|
|
elwoos
Flowing Fount of Yak Knowledge
United Kingdom
2040 Posts |
Posted - 10/05/2005 : 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!
|
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 10/05/2005 : 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... |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 10/05/2005 : 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 |
|
|
|
madhivanan
Premature Yak Congratulator
India
22469 Posts |
Posted - 10/05/2005 : 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 |
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 10/05/2005 : 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... |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madhivanan
Premature Yak Congratulator
India
22469 Posts |
|
|
mramir74
Starting Member
USA
3 Posts |
|
|
bakerjon
Posting Yak Master
USA
145 Posts |
Posted - 10/05/2005 : 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
|
|
|
| |
Topic |
|
A good tool for DBA
