Page History

This build of of  IDERA SQL Admin Toolset includes many fixed issues, including the following previously-released updates.

1.8 New features

SQL Server 2014 support

The tools available in the IDERA SQL Admin Toolset now support SQL Server 2014.

1.8 Fixed issues

There are no fixed issues in this release.

1.7 New features

There are no new features in this release.

...

• The SQL Discovery tool now displays only a single error message when a user scans a list of computers and one or more of the servers is unreachable.
• The SQL discovery SQL Discovery tool no longer crashes when opened in a Windows 7 or Windows 2008 R2 environment.

...

The Server Statistics tool now returns all the correct data when connected to a SQL server SQL Server 2012 database.

Server Ping tool

...

The tools available in the IDERA SQL Admin Toolset now support SQL Server 2012.

...

Special characters are no longer supported when naming new SQL Server groups. Support does continue for existing server groups which were created by IDERA SQL Admin Toolset version 1.2 or earlier, that contain special characters.

...

You can successfully search for text strings in a SQL Server job even if the MSDB system database is not listed in your search criteria.

1.2 Fixed issues

General

• This release offers full support for SQL Server 2008.
• You may now browse and select databases on a single server. Multiple databases on server groups must be added manually.
• All server browse lists include any servers defined in server groups.
• You can copy error reports to the clipboard.

Connection Check

Windows Authentication field allows a connection test to be run under an alternate user account.

Database Configuration

Added a new comparison report.

Database Mover

• Database Mover now supports database clusters.
• When moving a database, you have the option to set the default database for all of the migrated users to be the matching databases on the destination server.
• When a database is moved, the database owner is also copied to the destination server.
• When selecting a destination, you can browse to servers on different drives.
• A database can be renamed and copied to the same server instance.

Index Analyzer

You can select individual or multiple databases before running the Index Analyzer.

Inventory Reporter

Server Inventory now includes fields for: TCP Port Setting, Memory Allocation Type, Minimum SQL Server Memory, Maximum SQL Server Memory, Allocated CPU Count, Allocated CPU Count I/O, Number of Physical Processors, Number of Logical Processors, and a list of enabled SQL Server Network Libraries.

Job Mover

Moving jobs with multiple steps no longer causes an error.

Partition Generator

Viewing details of a partitioned table no longer generates an error message.

Password Checker

• Results can be exported as a TXT, CSV, or XML file.
• Results show the servers tested, the number of logins tested, bad passwords, blank passwords, and passwords that match the login.
• Additional password dictionaries have been added to the default list.
• You may select multiple dictionaries to use simultaneously.

Patch Analyzer

Results are sorted by SQL Server name, and can be further sorted by column within each group.

Quick Reindex

• The index results are no longer automatically resorted after reindexing.
• You have the option to turn off the reindexing warning message.
• You can select individual databases before loading index statistics.

Server Configuration

• Configuration information now includes service pack level, server collation, and login audit information.
• Comparison results now display differences in server collation values. These differences cannot be updated.

Server Ping

You can now start, stop, pause, resume, and restart SQL Server instances.

Server Statistics

• The server state is now correct for SQL Server 2000.
• The results for per-second counters (e.g. logins/sec) are more accurate.

Space Analyzer

• The Space Analyzer tool now has the ability to display space information for local mount points. However, it only detects mount points on Windows 2003, 2008, and Vista, and the mount point must host a valid database.
• Results now include system databases (e.g. tempdb, msdb).
• Results include a new column % Disk Used by Database File showing how much disk space is used by the selected file.

SQL Discovery

When scanning, you may enter a range of IP addresses or a local subnet.

User Clone

• The Default Database field for a new user correctly displays databases from the destination SQL Server.
• Source User displays all Windows authenticated group logins.
• You have the option to exclude role-level object permissions.

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >

...

...