I thought it would be useful to list the range of software utilities I use when managing SQL Server.
They cover object management, monitoring, troubleshooting, code writing, copying lareg files.
I specifically haven't added Profiler even throughI use it extensively.
I'd be interested in hearing your feedback and also finding out what other tools other utilites DBAs use.
SQL server Management Studio
Powershell - great for task automation and manageing large SQL server inventories
Command Shell
Tivoli Storage Manager
Winzip
ESEUTIL - Use to copy very large files - non buffering approach. Much faster than COPY
Tivoli Monitoring
Microsoft Management Console - Allows me one console to manage RDP, Active Directory, Compute Management
SQLCMD - Utility to run statements and script files. Command line interface
Programmers Notepad - Excellent and probably the best code editor I've used
SQLIO - returns IO capacity data. Free utility from Microsoft
TableDiff.exe - very useful utility, for comparing two tables. Installed with SQL Server.
SQLDumper.exe
Republished from http://www.sqlserver-dba.com.
Republished from SQL Server DBA [65 clicks].
Read the original version here [32134 clicks].