Online Documentation for SQL Administrator for SQL Server

Version history

 Version 1.4

1. Added support of new SQL Server 2014 features:
2. • Support of backup encryption.
   • Support of backup to Windows Azure.
   • Support of memory-optimized files and filegroups.
   • Support of new server-level permissions: CONNECT ANY DATABASE, IMPERSONATE ANY LOGIN, SELECT ALL USER SECURABLES.
   • Support of maintenance plans on SQL Server 2014.
2. Added ability to clone server objects including jobs and maintenance plans to the same or another server.
3. Server Explorer | Security view. Added the Credentials view which allows browsing and managing credentials.
4. Server Explorer | Security view. The logins of securityadmin server role (having the ability to assign most server permissions) are displayed in the System and Security Administrators list.
5. Database Editor.
6. • The support of some previously unsupported SQL Server 2012 and 2014 databases properties has been implemented.
   • The default size of a database file was 3Mb that is lower than the minimum allowed size for SQL Server 2012. It caused an error while saving the database properties. Fixed now.
   • After deleting a database file it appeared in the list but was actually removed from the server. Fixed now.
6. Query tool. The height of the grid now automatically fits the height of the parent data view area when it is changed.
7. Backup wizard. The ability to set the 'Server default' value for the backup compression option added now.
8. Server Explorer | Database Users, Roles, Application Roles views. The Description field added.
9. Server Explorer | Databases view. The ID field added. It is hidden by default and can be shown using Column Chooser dialog.
10. Alarm Summary | Databases without Backup alarm. Backup check interval is now 8 days by default for new server registrations.
11. Server Explorer | Database Users view. The Orphaned flag was incorrectly shown for some users on SQL Server 2012 although the corresponding alarm worked right. Fixed now.
12. Alarm Summary. If the database name contained the specific characters that should be quoted, the ‘Incorrect syntax’ error occurred in the alarm status. Fixed now.
13. If the error occurred on creating Maintenance Plan on SQL Server 2012 the Ssis11Adpt.exe process was not finished with the program. Fixed now.
14. Lots of other improvements and bug-fixes.

 Version 1.3

1. Compare Server Configurations wizard is implemented. It allows saving to repository, comparing and restoring configuration of SQL Server. It is allowed to compare saved server configurations as well as configurations of two servers. Configuration includes the following: server information, server properties, server configuration options, database options, database files and filegroups, server and database principals, server and database object permissions.
2. Added Register Servers form, which allows registering SQL Servers of local area network.
3. In the Server Connection dialog of a query window it is possible to select the current database for query execution immediately. There is a list of recently selected databases.
4. Query execution tool.

• Added shortcuts Alt+key for some commands of the toolbar.
• The list of non-reserved server words for highlighting and Code Completion is enlarged.
• When editing file without server connection and when opening Code Completion the error "Object reference not set to an instance of an object" occurred. Fixed now.

5. Wizards.

• After each new start of the wizard log of operation execution result scrolls so that new execution data appear in the upper line of the window.
• After loading a template, its file is blocked for editing. Fixed now.

6. When opening the Maintenance plan editor from Alarm Summary and saving the error "Maintenance plan with 'XXX' names already exists" occurred. Fixed now.
7. When opening Blob Editor of read-only query field, the upload from file button remained active. Fixed now.
8. Permissions. It was impossible to revoke permissions set by the current user. Fixed now.
9. Server Registration, Server Group, Windows and other dialogs. Added shortcuts Alt+key for focusing some dialog controls. (Shown after pressing Alt).
10. Windows dialog. Close button overlapped Help button. Fixed now.
11. Backup wizard. When using apostrophe character (‘) in backup name, backup description, media set name, media set description fields and executing the error occurred. Fixed now.
12. SQL Editor.

• When deleting text from the end of the line till space, the space was also deleted. Fixed now.
• Clicking the scrollbar to move page up did not work. Fixed now.

13. Options dialog. The field where the software log file name is set now contains the open file button.
14. Lots of other improvements and bug-fixes.

 Version 1.2

1. Query execution tool.

• The results of the query execution can be edited now. (The table should have the primary key.)
• BLOB Editor is implemented to view/edit the values of BLOB fields.
• The grid navigator to shift the records and edit the query results is added.

1. Server Explorer. It is possible to start/stop server now.
2. Wizards. The context menu of the execution log now contains Select All and Copy.
3. Statistics Collector State dialog. The progress on start/stop of the service is shown now.
4. Multiple choice dialog (e.g., choice of server role members) contains the context menu with Select All/Unselect All commands.
5. Maintenance Plans. Maintenance Plan History button was not disabled if the plan list was empty. Fixed now.
6. Collected Statistics Trend. Show Details button was not disabled if the list was empty. Fixed now.
7. Lots of other improvements and bug-fixes.

 Version 1.1

1. Data grids and chart views of Server Explorer, query data, Alarm Summary now can be printed or exported in several popular formats.
2. To the Server Explorer data grids the incremental search is added.
3. Server Explorer | Current and Collected Statistics | Chart View Customization. Now the Add Performance Counter dialogue displays its description.
4. Server Explorer | Maintenance | Check Database. Added a column of the last successful database check date.
5. Server Explorer | Storage | Databases. In the context menu the "Recover without Restoring" command is now available for databases being in restoring state.
6. Backup Database wizard. Database icons are now displayed together with their (database) statement.
7. Server Explorer | Maintenance | Backup | Failed Backups. Now when calling the Backup Database wizard, a database name is inserted from the current view string.
8. Server Explorer. In some cases when opening the Maintenance views the "An element with the same key already exists" error occurred. Fixed now.
9. When registering a server from the main menu of the program, the current server group was not specified. Fixed now.
10. If in Server Explorer a server group is selected, when calling a New Query this server group is specified in the Connect to Server dialogue.
11. Other improvements and bugfixes.

 Version 1.0

• Managing maintenance tasks, monitoring their performance schedule, periodicity and the last execution result.
• Detecting and informing about possible failures.
• Managing SQL Server storage. Ability to get information about disk space used by databases/separate objects and to forecast disk space exhaustion.
• Collecting and analyzing performance statistics of the system and SQL Server. Ability to find performance bottlenecks and predict their occurrence.
• Easy and intuitive SQL Server environment Security Management.
• Monitoring server activity, analyzing server logs.
• Creating/modifying/dropping different server objects.
• SQL queries and scripts execution.

Scroll to top