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.