Softpedia >Windows >Internet >Servers >Server Tools >SQL Administrator for SQL Server >  Changelog

SQL Administrator for SQL Server Changelog

What's new in SQL Administrator for SQL Server 2.0.0.340

Jul 7, 2015
  • Database Explorer is added: new tool for viewing information of database and databases objects and managing them.
  • Database Explorer | Database tab. Main information on the database state is displayed here, namely: values of its properties and options, dates and results of service tasks execution, location of the latest database backup, database size and growth, information on the files and latency at their access and many other. Clamant values are being lighted up. Here one can perform various actions with the database: make a backup, verify its integrity, refresh indices, create an object etc.
  • Server Explorer | Server tab. Information volume concerning the server has been considerably increased. Now it is possible to create/edit/delete objects right here with no need for opening the appropriate tabs of the Server Explorer. For user’s convenience alarms can be browsed in the form of vertical grid.
  • Server Explorer | Performance. Now all the most important information on the current server load is gathered here in the form of graphs and tables.
  • New freeware version with limited features is released.
  • Server Explorer | Maintenance. Now the date and the status of the last execution of each server maintenance task for all server databases are displayed here.
  • New alarms have been added:
  • High Disk Transfer Latency
  • Low Page Life Expectancy
  • Databases in Restricted User Mode
  • Databases in Non-Online State
  • Errors in Server Error Log
  • For WMI connection to server, which is used for receiving the system information and counter values, now one can set Windows login/password different from the current one.
  • Statistics Collector. The following counters are also collected now:
  • Paging File. % Usage
  • Physical Disk. Avg. Disk sec/Read
  • Physical Disk. Avg. Disk sec/Write
  • Physical Disk. Disk Reads/sec
  • Physical Disk. Disk Writes/sec
  • SQL Server: Buffer Manager. Page life expectancy
  • SQL Server: Memory Manager. Memory Grants Pending
  • SQL Server: SQL Statistics. Batch Requests/sec
  • Server Explorer | Server group tab. For more convenient data scanning the data is presented in the form of vertical grid. Here additional information on the servers is also displayed.
  • User, Role, Application Role Editors. In addition to the possibility to browse and edit permissions of the given principal, there has appeared the possibility to set permissions for the given principal.
  • Default size of objects editors has been enlarged.
  • Server Explorer | Alarm Summary. The representative width has been limited, and other visual amendments have been made.
  • Maintenance Plan Editor. Now it has become more convenient to create tasks for one and the same database - there is no need to open database picker dialog every time, databases from the previous tasks are added to the combobox.
  • The height of popup menus for comboboxes has been increased – it used to be inconvenient to search the required element in the long list.
  • Large number of other improvements and bug fixes.

New in SQL Administrator for SQL Server 1.4.0.367 (Sep 30, 2014)

  • Added support of new SQL Server 2014 features:
  • 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.
  • Added ability to clone server objects including jobs and maintenance plans to the same or another server.
  • Server Explorer | Security view. Added the Credentials view which allows browsing and managing credentials.
  • 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.
  • Database Editor. - 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.
  • Query tool. The height of the grid now automatically fits the height of the parent data view area when it is changed.
  • Backup wizard. The ability to set the ‘Server default’ value for the backup compression option added now.
  • Server Explorer | Database Users, Roles, Application Roles views. The Description field added.
  • Server Explorer | Databases view. The ID field added. It is hidden by default and can be shown using Column Chooser dialog.
  • Alarm Summary | Databases without Backup alarm. Backup check interval is now 8 days by default for new server registrations.
  • 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.
  • 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.
  • If the error occurred on creating Maintenance Plan on SQL Server 2012 the Ssis11Adpt.exe process was not finished with the program. Fixed now.
  • Lots of other improvements and bug-fixes.

New in SQL Administrator for SQL Server 1.4.0.267 (Sep 30, 2014)

  • Support of new SQL Server 2014 features, cloning server objects, managing credentials and a lot of other improvements and bug-fixes

New in SQL Administrator for SQL Server 1.3.0.1 (Feb 5, 2014)

  • 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.
  • Added Register Servers form, which allows registering SQL Servers of local area network.
  • 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.
  • 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.
  • 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.
  • When opening the Maintenance plan editor from Alarm Summary and saving the error "Maintenance plan with 'XXX' name already exists" occurred. Fixed now.
  • When opening Blob Editor of read-only query field, the upload from file button remained active. Fixed now.
  • Permissions. It was impossible to revoke permissions set by the non-current user. Fixed now.
  • Server Registration, Server Group, Windows and other dialogs. Added shortcuts Alt+key for focusing some dialog controls. (Shown after pressing Alt.)
  • Windows dialog. Close button overlapped Help button. Fixed now.
  • 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.
  • 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.
  • Options dialog. The field where the software log file name is set now contains the open file button.

New in SQL Administrator for SQL Server 1.2.0.1 (Aug 29, 2013)

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

New in SQL Administrator for SQL Server 1.1.0.1 (May 30, 2013)

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