24 SQL Server Administration Tools to Simplify Day-to-Day Tasks
SQL Admin Toolset
- 24 essential desktop tools for your everyday SQL Server needs
- Run every day diagnostics across multiple SQL servers
- Complete administrative tasks in minutes, not hours
- Perform analysis on your SQL data
- Eliminate time spent developing, testing and maintaining custom scripts
SQL Backup Status
Check whether your databases are backed up
Search for text anywhere you have SQL code (stored procedures, functions, triggers, etc.)
SQL Object Search
Find objects by name anywhere they are hiding in your SQL servers
Find the SQL servers lurking on your network
SQL Password Checker
Check the strength of your SQL Server passwords
SQL Connection Check
Diagnose connection problems and quickly determine why users can’t reach your SQL servers
SQL Multi Query
Execute and manage queries across multiple SQL servers
SQL Database Mover
Move or copy a database and associated logins across servers or relocate data files
SQL Login Copy
Copy server logins across SQL servers
SQL User Clone
Create a new user using an existing user as a template
SQL Job Mover
Move and copy between servers
SQL Job Editor
View and edit jobs across multiple SQL servers
SQL Quick Reindex
Quickly review and rebuild the indexes on your SQL servers
SQL Server Configuration
Compare and edit server configuration for one or more SQL servers
SQL Database Configuration
Compare and edit database configuration for one or more databases
SQL Partition Generator
View existing partition information and generate new partitions
SQL Connection String Generator
Wade the multitude of options for connection strings and create your own in seconds
SQL Server Linked Copy Tool
Quickly and easily copy linked servers from one server to another
SQL Inventory Reporter
Get a list of everything important about your SQL servers, including version, hardware and more
SQL Patch Analyzer
Report and analyze your SQL Server version levels
SQL Index Analyzer
Analyze your indexes for usage patterns and sizes. Determine if you need more, less, etc.
SQL Space Analyzer
Analyze space utilization of your SQL Server by drive or database
SQL Server Statistics
View loads of statistics about your SQL Server
SQL Server Ping
Keep a constant eye on the status of your SQL servers
SQL Admin Toolset contains six diagnostic tools for SQL Server to check the status of backups, search for SQL text and objects in instances, find instances on the network, verify the strength of login passwords, and diagnose instance connection problems.
Safeguard that SQL Server databases have proper backups, identify databases that have no backup, know when databases were last backed up, identify disabled and failing backup plans, and view backup status across all instances. When it is time to restore, do not find out that recent backups do not exist.
Find words and phrases in SQL code, perform a global search and replace, search for exact words, phrases, and wildcards, see the full SQL source in search results, and save search results. Save time on tasks like updating copyright notices and changing all usages of stored procedure calls.
Find objects across SQL Server environments, search for words and phrases used in object names, search across all objects in instances and server groups, search using wildcards, and save search results. Determine where particular objects (such as tables) exist and the number of specific objects (such as logins) residing in instances.
Find new and rogue SQL Server instances on networks, use multiple scan types to increase search effectiveness, create server groups for recently detected instances, and check the configuration of discovered instances. Identify and group newly found instances. Then properly lock down these instances to prevent future security issues.
Find weak passwords that make SQL Server instances vulnerable to attack, replace weak passwords with strong passwords, use industry best practices, and company password policies to test password strength, and save test results. Eliminate weak passwords and security holes from instances.
Identify connection problems for SQL Server instances, diagnose why user cannot login to instances, check the status of instances, host computers, network connections and client machines, resolve connection problems using best practices, and save time by offloading connection troubleshooting to help desks.