| 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. |
 |
|
|
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 |
|
|
|
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.  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-05 : 01:23:14
|
| FWIW Query Analyzer and Enterprise Manager are all we use.Kristen |
|
|
|
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 MadhivananFailing to plan is Planning to fail |
|
|
|
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 |
|
|
|
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 themselvessteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
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 MadhivananFailing to plan is Planning to fail
--------------------keeping it simple... |
|
|
|
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 |
|
|
|
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 MadhivananFailing to plan is Planning to fail |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-05 : 09:51:32
|
i actually used once, but learned my lessonsDBA101, backup and restorequote:
Originally posted by madhivanan
>>though a good DBA will not need one I hope you dont need that MadhivananFailing to plan is Planning to fail
--------------------keeping it simple... |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
mramir74
Starting Member
3 Posts |
|
|
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 |
|
|
|
|
A good tool for DBA