This build 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.
1.7 Fixed issues
Backup Status tool
This release corrects an issue causing the Backup Status tool to unnecessarily increase memory consumption.
SQL Search tool
This release corrects an issue causing the SQL Search tool to include excerpts that did not contain the search string.
SQL Discovery tool
- 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 tool no longer crashes when opened in a Windows 7 or Windows 2008 R2 environment.
Connection Check tool
The Server Health Check function of the Connection Check tool now properly connects with SQL Server authentication credentials.
Multi Query tool
This release fixes a possible handle leak in the Multi Query tool.
Database Mover tool
This release corrects an issue causing the Database Mover tool to lock when copying a large database.
User Clone tool
The User Clone tool now properly clones explicit permissions for a database.
Job Mover tool
This release corrects an issue preventing the Job Mover tool from copying the job output file settings.
Quick Reindex tool
- Users who run an edition of SQL Server that supports online index rebuilding now can use that feature in the Quick Reindex tool.
- The Quick Reindex tool now includes the Fill Factor column in the SQL Server 2000 version.
- If you want to rebuild multiple indexes with varying fill factor settings, the Quick Reindex tool allows you to retain the current setting of each index by selecting the Current Fill Factor option in the Index Settings area. Note that the index list also includes the Fill Factor column for you to quickly view the fill factor settings of each index.
- This release corrects an issue causing the Quick Reindex tool to use the old Fill Factor entry when the entry is manually changed on the back end without first loading the index statistics.
- This release corrects an issue causing the Quick Reindex tool to display an incorrect fragmentation percentage.
Partition Generator tool
The Partition Generator tool no longer displays an error message when a user attempts to use the tool on servers running SQL Server 2008 R2 Data Center Edition.
Inventory Reporter tool
- This release corrects an issue causing the Inventory Reporter tool to show an exception error when you have the Show Servers as Rows option turned on, and then click Copy.
- This release corrects an issue causing the Inventory Reporter tool to switch the results of the Minimum SQL Server Memory and Maximum SQL Server Memory columns.
Index Analyzer tool
- The Index Analyzer tool now properly displays the Fill Factor column to display statistics for analyzed indexes.
- This release corrects an issue causing the Index Analyzer tool to show an exception error when you type an alphabetic character into the Hide Indexes under X rows field.
- Corrected an issue preventing the proper function of the Hide Non-Clustered Indexes check box.
- The Index Analyzer tool now displays an accurate Selectivity percentage and the correct total number of records displayed.
Space Analyzer tool
The new Auto Unit field in the Space Analyzer tool allows you to select the unit of measurement that best displays your results.
Server Statistics tool
The Server Statistics tool now returns all the correct data when connected to a SQL Server 2012 database.
Server Ping tool
This release corrects an issue causing the Server Ping tool to show an exception to SQL Server 2000 Enterprise Manager users with a local server.
1.6 New features
SQL Server 2012 support
The tools available in the IDERA SQL Admin Toolset now support SQL Server 2012.
1.5 New features
New Linked Server Copy tool
The new Linked Server Copy tool lets you quickly and easily copy our Linked Servers from one SQL Server instance to another along with the associated settings, logins, passwords, and permissions.
New options for the Quick Re-Index tool
The Quick Re-Index tool now allows you to:
- Specify which fill factor you want to use when the selected index is rebuilt.
- Enable online processing during rebuild.
- Use the Maxdrop setting to specify he maximum degree of parallelism to use during the rebuild.
1.5 Fixed issues
Index Analyzer
You can now view a list of columns of an index in the order that they were defined.
Patch Analyzer
Patch Analyzer now includes the latest SQL Server service packs.
Multi Query
- Multi Query now correctly sorts the returned results.
- You can now use multi-line strings when performing a query.
Space Analyzer
The Space Analyzer tool now correctly reports the value for the Maximum Potential Size metric.
1.3 Fixed issues
Job Editor
You can now successfully retrieve job information from a server group that contains duplicate SQL Server instances.
Job Mover
You can now successfully move SQL Server jobs whose names contain single quote marks (').
Multi Query
You can now successfully clear the returned results of your query from the Query Execution and Results pane.
Server Groups
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.
SQL Search
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.