24 Incredibly Useful Tools
Diagnostic
Backup Status:
Check whether your databases are backed up
SQL Search:
Search for text anywhere you have SQL code (stored procs, functions, triggers etc..)
Object Search:
Find objects by name anywhere they are hiding in your SQL Servers
SQL Discovery:
Find the SQL Servers lurking on your network
Password Checker:
Check the strength of your SQL Server passwords
Connection Check:
Diagnose connection problems, quickly determine why users can’t reach your SQL Servers
Administration
Multi Query:
Execute and manage queries across multiple SQL Servers
Database Mover:
Move or copy a database and associated logins across servers or relocate data files
Login Copy:
Copy server logins across SQL Servers
User Clone:
Create a new user using an existing user as a template
Job Mover:
Move and copy between servers
Job Editor:
View and edit jobs across multiple SQL Servers
Quick Reindex:
Quickly review and rebuild the indexes on your SQL Servers
Server Configuration:
Compare and edit server configuration for one or more SQL Servers
Database Configuration:
Compare and edit database configuration for one or more databases
Partition Generator:
View existing partition information and generate new partitions
Connection String Generator:
Wade the multitude of options for connection strings and create your own in seconds
Table Pin:
View and manage the pinned status of your tables (SQL Server 2000 and earlier only)
Analytics
Inventory Reporter:
Get a list of everything important about your SQL Servers, including version, hardware and more
Patch Analyzer:
Report and analyze your SQL Server version levels
Index Analyzer:
Analyze your indexes for usage patterns and sizes. Determine if you need more, less etc…
Space Analyzer:
Analyze the space usage of your SQL Server by drive or database
Server Statistics:
View loads of statistics about your SQL Server
Server Ping:
Keep a constant eye on the status of your SQL Servers
