ApexSQL Manage release notes

Fixes:

• 197154: "Type 'Microsoft.Data.SqlClient.SqlException'" error is encountered when performing the "On all databases disable guest user (except on system and temp)" health check rule on databases in restoring state or in single user mode
• 203233: Both ApexSQL Manage and ApexSQL Manage Agent windows service run as 32-bit applications on 64-bit operation systems

Enhancements:

• ApexSQL Job is now called to list, add, edit and remove SQL Server Agent jobs for a selected SQL Server instance
• The Activities tab offers an overview of operations performed on a SQL Server instance
• Rule parameters can now be configured from the health check rule wizard
• Health check analysis can now be automatically reinitiated after a FixSQL script successfully completes
• The Security health check rules are now complete with a new set of predefined rules

Fixes:

• 176593: Fix SQL script for the "Database Full Recovery mode must be enabled" health check rule doesn't recognize the target database
• 184521: "Can't connect to server" message is displayed when Fix SQL button is clicked for a server that is added manually or is not a part of a domain
• 173365: Documentation process is not stopped when Stop button in the Generating documentation dialog is used
• 192324: "DNS.Client.ResponseException: Invalid response received with code FormatError" error is encountered when performing DNS scan

Enhancements:

• 36 new rules added to the Security category to extend the range of health check analysis

Fixes:

• 187389: The application stops responding after the login is created with SQL Server authentication
• 189280: "Please wait... Performing quick health check" message is shown after a quick health check is executed on the offline remote SQL Server instance
• 188980: When comparing a SQL Server instance with its snapshot the same name is displayed in source and target columns of the comparison grid creating confusion
• 189279: "Please wait. Refreshing..." message is shown and the application stops responding after its initial startup

Enhancements:

• 13 new rules added to the Security category to extend the range of health check analysis

Fixes:

• Scheduled operations skip all targeted SQL Server instances when one SQL Server instance is in maintenance period

Changes:

• Error handling and send logs functionality has been modified

Enhancements:

• ApexSQL Mask can now be called from the main menu
• The predefined health check rules can now be used as a template when creating new custom rules
• Newly discovered SQL Server instances can now be automatically added to the managed servers list after a scan process is completed

Fixes:

• All checked SQL Server instances are skipped when maintenance period is detected on one instance during the scheduled operation

Enhancements:

• All managed jobs can now be scheduled
• Email notifications for scheduled jobs can now be configured
• Maintenance periods can now be defined

Fixes:

• Comparison results are not shown between two snapshots

Features:

• Supports SQL Server 2005 and higher
• Discover and list SQL Server instances, SSRS, SSAS and SSIS services on network
• Perform health check on SQL Server instances and view statistics
• Run SQL scripts to fix failed health check issues
• Create SQL Server instance snapshots
• Make comparison between SQL Server instances and snapshots
• Create detailed documentation for SQL Server instances and snapshots
• Manage SQL Server logins
• Manage SQL Server health check rules
• View instance details for selected SQL Server
• Filter health check results
• Export results to WORD, PDF or XML
• GUI themes
• High DPI and 4K resolution support
• Application telemetry collects anonymous data on the use and performance of application and application components
• ApexSQL Updater configures advanced updating settings of all installed ApexSQL products