24 SQL Server Administration Tools to Simplify Day-to-Day Tasks

SQL Admin Toolset

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.

Backup Status

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.

SQL Search

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.

Object Search

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.

SQL Discovery

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.

Password Checker

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.

Connection Check

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.

SQL Admin Toolset contains twelve administration tools for SQL Server to manage queries across instances, migrate databases and their logins across instances, manage jobs across instances, copy logins across instances, create new logins based on existing logins, manage index fragmentation, compare and modify instance and database settings, view and generate partitions, create connection strings, and copy linked servers across instances.

Multi Query

Run queries against multiple SQL Server instances and databases at the same time, make changes in bulk, create and reuse target lists of instances and databases, save the returned result sets, and track statistics and object properties over time. Saves lots of time by quickly performing operations on multiple instances at once.

Database Mover

Move and copy databases from one SQL Server instance to another, move and copy logins along with the database, copy and rename a database on the same instance, and relocate the data files for a database to a different storage device while keeping the database on the same instance.

Login Copy

Synchronize SQL Server instances logins between two instances, compare instances to see which logins do not match, and supplement existing backup and recovery scripts by capturing the logins stored outside the databases at the server level. Administering logins on parallel environments (such as test and production systems) can be a challenging and time-consuming task. Login Copy solves this problem.

User Clone

Create new SQL Server logins using existing logins as templates, create new users by cloning existing users, immediately perform the clone operation, generate, preview and edit T-SQL scripts, copy logins across instances to maintain consistent permissions on every instance, and create scripts for use in new login workflows.

Job Mover

Move SQL Server jobs from one instance and database to another, copy jobs from one instance and database to another, preserve assigned user privileges when moving jobs, and copy jobs from staging to production servers.

Job Editor

Edit SQL Server jobs, perform updates to jobs in bulk across an environment, get a comprehensive view of all jobs in SQL Server environments, see full job properties like status, owner and last run outcome, and export data to use in scripts and applications.

Quick Reindex

Reindex SQL Server instances, view fragmentation levels across indexes, rebuild and reorganize indexes to reduce fragmentation levels, filter results by instance, database and table, sort indexes based on fragmentation level, size and name, and filter to hide small and disabled indexes.

Server Configuration

Review, compare, and edit configuration settings of one and multiple SQL Server instances, diagnose problems and identify unwanted differences, identify configuration changes over time, roll out configuration changes to one and multiple instances, and report on configuration settings by instance and by server group.

Database Configuration

Review, compare and edit configuration settings of one and multiple databases, diagnose problems and identify unwanted differences, identify configuration changes over time, roll out configuration changes to one and multiple databases, and report on configuration settings by instance and by server group.

Partition Generator

Create and manage SQL Server table partitions, determine whether tables are partitioned and should be partitioned, create partitions and specify data ranges, and change existing partitions by merging and splitting data ranges.

Connection String

Build SQL Server connection strings, eliminate the need to research and memorize all available connection string options, and test connection strings before copying them into SQL code.

Linked Server Copy

Easily copy login credentials for remotely linked SQL Server servers, view all available linked servers, monitor the status of login passwords that are movable, easily see the move status of copied permissions that, and maintain remote connectivity for query login permission.

SQL Admin Toolset contains six analytic tools for SQL Server to inventory instances and host computers, check for latest patches, analyze the usage patterns of indexes and the space usage of instances by drive and database, view statistics and counts for instances, and monitor the status and availability of instances.

Inventory Reporter

Capture inventory and configuration details about SQL Server instances and their host computers, compare captured inventory data against previous snapshots and other instances, highlight differences, create inventory reports, and export data for use in scripts and application.

Patch Analyzer

Keep SQL Server instances properly patched, identify unsupported versions of instances running on servers, identify available service packs and hotfixes, view Microsoft Knowledge Base articles associated with service packs and hotfixes, see comprehensive lists of all service packs and hotfixes for each version of SQL Server, and export data for use in scripts and applications.

Index Analyzer

Optimize the use of indexes on SQL Server databases, view index usage, analyze the usefulness of each index, examine selectivity levels across indexes, and see vital statistics (such as the number of rows modified and ratio of accesses to row updates) essential for balancing the index usage for data updates and queries. Maximize the performance of databases by applying correct indexes and eliminating bad ones.

Space Analyzer

Identify the disk space and storage usage for SQL Server instances, identify runaway log files, proactively anticipate when new instances need to be brought online, and plan for new databases and hardware upgrades.

Server Statistics

Determine the health of SQL Server instances by collecting real-time statistics, view detailed metrics (such as backup devices, databases, error logs, locks, logins, performance counters, processes, and SQL agent jobs), and compare statistics from one instance to another.

Server Ping

Monitor the status of SQL Server instances across the environment by routinely pinging specified instances. Execute the tool as centralized user interface and as system tray service that alerts when instances go offline and become unhealthy.”

No credit card required! Fully functional for 14 days

Buy Now

Includes first year of maintenance.

Add to Cart

Buy online now and save 40% Use code SQLADM40 at checkout

Request a Quote

Live product Demo

See SQL Admin Toolset in action with a seasoned pro.

Request a Demo