Idera SQL Admin Toolset includes 25 essential desktop tools to simplify your day-to-day administration tasks. You can run your every day diagnostics across multiple SQL Servers in minutes instead of hours.
SQL Admin Toolset diagnostic tools
Check whether your databases are backup up properly.
Search for text anywhere you have SQL code, such as stored procedures, functions, and triggers.
Find objects by name anywhere they are hiding in your SQL Servers.
Find the SQL Servers lurking on your network.
Check the strength of your SQL Server passwords.
Diagnose connections problems, quickly determine why users cannot reach your SQL Servers.
SQL Admin Toolset administration tools
Execute and manage queries across multiple SQL Servers.
Move or copy a database and associated logins across servers or relocate data files.
Copy server logins across SQL Servers.
Create a new user using an existing user as a template.
Move and copy between servers.
View and edit jobs across multiple SQL Servers.
Quickly review and rebuild the indexes on your SQL Servers.
Compare and edit server configuration for one or more SQL Servers.
Compare and edit database configuration for one or more databases.
View existing partition information and generate new partitions.
Wade the multitude of options for connection strings and create your own in seconds.
Quickly and easily copy linked servers from one server to another.
SQL Admin Toolset analytic tools
Get a list of everything important about your SQL Servers, including version, hardware, and more.
Report and analyze your SQL Server version levels.
Analyze your indexes for usage patterns and sizes, and determine if you need more or less.
Analyze space utilization of your SQL Server by drive or database.
View loads of statistics about your SQL Server.
Keep a constant eye on the status of your SQL Servers.