Evaluate Weigh the pros and cons of technologies, products and projects you are considering.

SQL admin toolset 1.0

SQL admin toolset 1.0 has the ability to multi-query, check passwords, analyze indexes and patches, edit and move jobs and gather server statistics.

New Product Showcase for SQL Server Performance Tuning and MonitoringSQL admin toolset 1.0 is designed to give database administrators one desktop management console that has the ability to multi-query, check passwords, analyze indexes and patches, edit and move jobs and gather server statistics.

SQL admin toolset 1.0 includes a suite of 24 diagnostic, administration and analytical tools that give DBAs a view of their Microsoft SQL Server environment.

  SQL admin toolset 1.0

The six diagnostic tools allow DBAs to do the following:

  • Check whether databases are backed up.
  • Search for text anywhere there is SQL code (stored procs, functions, triggers, etc.).
  • Find objects by name anywhere in SQL Servers.
  • Find hidden SQL Servers on the network.
  • Check the strength of SQL Server passwords.
  • Diagnose connection problems to determine why users can't reach SQL Servers.

SQL admin toolset 1.0
Figure 1: A screenshot of SQL admin toolset 1.0. (Click on image for enlarged view.)

The 12 administration tools allow DBAs to do the following:

  • 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.
  • Move and copy between servers.
  • View and edit jobs across multiple SQL Servers.
  • Review and rebuild indexes.
  • 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.
  • View the options for connection strings and create your own.
  • View and manage the pinned status of tables.

The six analytical tools allow DBAs to do the following:

  • Get a list of important SQL Server data, including versions and hardware.
  • Report and analyze on SQL Server version levels.
  • Analyze indexes for usage patterns and sizes.
  • View SQL Server statistics.
  • Monitor the status of SQL Server.

System requirements: CPU 2.0 GHz or higher. 32-bit OS: Windows 2000 Server SP4 or higher, Windows XP SP2 or later, Windows Vista Business or Enterprise. 64-bit OS: Windows Server 2003 SP1 (x64 or Itanium 2), Windows XP Professional (x64) software applications. .NET Framework 2.0, SQL Server 2000 SP4 or later, SQL Server 2005 SP1 or later, SQL Server 2008.

Pricing: $495 per copy.

This was last published in February 2009

Dig Deeper on SQL Server Database Modeling and Design

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.