Aireforge Studio | Release Notes

Release Notes

v 2.3.2 14 Feb 2024

Module Description
Script Results to grid now auto sizes columns based on data and heading lengths.
General Updated ALL tooltips and headings. Tooltips, tooltips and then more tooltips.
Monitor Bug fix. Closing results tab now returns to Monitor, not Estate.

v 2.3.1 13 Feb 2024

Module Description
Estate Improvements to the add server dialog and progress bar.

v 2.3.0 12 Feb 2024

Module Description
General Upgrading the application will now run in SILENT mode, streamlining updates.
General Major changes to trials to enhance user experience, offering a smoother onboarding and evaluation process.
General Major changes to licensing, messaging, handling, and dialogs for a more intuitive and user-friendly experience.
General Resolving some dynamic sizing issues to improve UI responsiveness and adaptability.
General Removed HtmlAgilityPack & updated dependencies for improved performance and security.
Advisor Fixed NPE (NullPointerException) when sending from Advisor to Script, enhancing stability.
Advisor Improved Advisor screens for enhanced usability, providing a more intuitive user experience.
Advisor Build indexes online when using Enterprise or Developer editions, allowing for more efficient database management.
Script Change from 'Advisor>Script' to 'Send to Script' for clarity, simplifying user actions and terminology.
Estate Licensing can be administered from the login screen to avoid forced updates, providing more control over the licensing process.
Monitor Improved tab names for Monitor for better navigation, making it easier to switch between different monitoring aspects.

v 2.2.1 01 Feb 2024

Module Description
General The license now displays licensed Company or User.
General Resolved UI issue with message box icons.
General Resolved UI issue with watermarks.
General Code refactoring and simplification, especially around licensing.
General Fixed some long-standing issues with displaying text.
General Improvements to asynchronous license check.

v 2.1.1 31 Jan 2024

Module Description
General Added support for Beta, Dev, and Early access modes.

v 2.1.0 25 Jan 2024

Module Description
General Addressed the SQL Data Provider Security Feature Bypass Vulnerability

v 2.0.2 29 Sep 2023

Module Description
General Updated credits to include changes for .NET 6 support

v 2.0.1 28 Sep 2023

Module Description
General Upgraded to .NET 6 and compatible libraries
General Enhanced UI for better user experience
General Improved DPI scaling for high-resolution displays
Advisor Fixed Advisor issues for Azure SQL DB
Advisor Skipped heap indexes in duplicate/overlapping index check
General Tested additional server properties during connection validation
General Installer now checks .NET version and offers download link if necessary

v 1.21.8406.28012 07 Jan 2023

Module Description
General Improvements for 4k screens

v 1.21.8401.21483 01 Jan 2023

Module Description
Advisor Highlight if TF1117 & TF1118 have been added to SQL Server 2016 or newer
Estate Removed server version from server import dialog
Advisor Heaps are now taken into consideration when making suggestions
General UI improvements
Compare Added support for SQL Server 2022 and improved database check for SQL Server 2019
Advisor Don't suggest adding/converting a clustered index for unused or small (<255 rows) heaps
Advisor Resolved a bug when making missing index suggestions
Advisor Resolved a bug with socket/core check

v 1.20.8212.33518 26 Jun 2022

Module Description
Advisor Boost SQL Server Priority Check
Advisor CLR integration and related security options check
General Upgraded Aireforge to .NET 4.8
Advisor Renamed Optimize to Advisor
Monitor Renamed Check to Monitor
General Improved menu text and fixed typos
Advisor Skip Query Store checks for Express Edition
Advisor Affinity Type Check
Advisor xp_cmdshell check
Advisor Remote access check
Advisor Analyse worker threads
Advisor Blocked process threshold check
Advisor Ole automation procedures
Advisor Results layout improvements
Advisor Improvements to Query Store checks
Advisor Expanded the affinity check to include processor and I/O
Advisor Ignore disabled constraint that have been generated by a SQL Server component
Advisor Ensure Query Store trace flags are enabled if Query Store is in use
Advisor Suggest trace flag to suppress successful backup messages
General Do not open JSONs once saved
General Prevent opening RDP for everything but SQL Server
Advisor Check for Scan for Startup Procs
Advisor Check for Data Purity Checks
General Support for SQL Server 2022
Advisor Improved the message when the fill factor is explicitly set to the same server default
Advisor Advisor will no longer attempt to run for unsupported versions of SQL Server
Advisor Suggested indexes follow the index naming convention and do not clone the stats of existing indexes

v 1.19.8046.25926 11 Jan 2022

Module Description
Optimize No longer recommends dropping unused indexes that are unique or unique constraints.
General Resolved some spelling mistakes in the app and on the site, impacting the compatibility checks.
Optimize Removed Optimize from the standard trial (available on request).
Compare It's now possible to export Comparisons to JSON.
General Updated the MSSQL versions.
Optimize Standardise the categories and brought them inline with other industry tools.
Optimize Added basic support for SQL Server 2022 and Azure Synapse.
Optimize Check hosts for incorrectly configured or wasteful CPU / Socket configurations
Optimize It's now possible to export Optimize to JSON.

v 1.18.7788.23001 28 Apr 2021

Module Description
Compare Fixed a bug within the comparison differences results view.
General Provided deprecated license key information for Aireforge Pro users attempting to validate old licenses.

v 1.18.7778.33382 20 Apr 2021

Module Description
Optimize We now flag items as unused after 90 days.
Optimize Improved message for Query Store recommendations.
Optimize Duplicate and overlapping indexes now show the potential storage savings.
Optimize Fixed a bug with incorrectly reporting tables as having no clustered index.
General Migrated user licensing library to the latest major version.

v 1.17.7696.15356 26 Jan 2021

Module Description
Optimize Various improvements to the findings output.
Optimize Multiple Query Store issues will be highlighted if found.
Optimize Non-default fill factors check moved to Housekeeping.

v 1.17.7695.20378 25 Jan 2021

Module Description
Optimize More items are cached to improve the performance.
Optimize Improved output scripts for filtered indexes.
Optimize Optimize won't run for 2005 or before (our suggestions is to upgrade, it's 15 years old!!!).
Optimize Improved the information given when suggesting missing indexes.

v 1.17.7693.22378 23 Jan 2021

Module Description
Optimize Major improvements to missing index suggestions & information.
Optimize Missing index suggestions with low estimated impact scores can now be ignored (default 100,000).
Optimize Major improvements to the fragmented index suggestions & information.
Optimize Rebuild indexes now defaults to SORT_IN_TEMPDB = ON
Optimize Fixed a bug when ordering tables by missing index impact.
General Fixed a bug where Aireforge unable to obtain the instance version.
Script Expanded the list of T-SQL keywords.
General Improvements and standardization of the toolbar, icons and options.

v 1.17.7691.24850 21 Jan 2021

Module Description
Optimize Wide-ranging improvements to Optimize suggestions. Better formatting and more detail/metrics.
Optimize Fixed a bug with index column orders, which could result in incorrect suggestions.
General Added support for Azure Active Directory - Password & Integrated.

v 1.16.7520.27251 03 Aug 2020

Module Description
Optimize Fixed error with checking max memory on SQL Server 2016+ Enterprise Edition
Optimize Added a check to warn when the SQL Server version support is about to or has expired.
Optimize Ignore old backup history if there are less than 1,000 rows.
General Community Edition is now limited to 5 servers for Compare and Script.
Optimize Added support for LARGE_PAGES when check memory model.
Optimize Improved formatting within the Optimize result pane.
General Uninstalling Aireforge will now launch the website to request feedback.
Optimize Improved the output for failed logins check.
Optimize Improved output for data & log sizes.
Optimize Improved all documentation and explanation pages.

v 1.15.7375.34487 11 Mar 2020

Module Description
General Added Copy Hostname right-click functionality throughout each module
Check Added Launch RDP/SMSS right-click functionality to Results view
Compare Added Higher Resolution images for Check & Summary buttons
General Added Compare Selected Servers right-click functionality to Compare/Check/Script modules
General Added Optimize Highlighted Server right-click functionality to Estate/Check/Script modules
Estate Improved Discover from SSMS functionality.
Estate Documentation is from

v 1.14.7159.31284 08 Aug 2019

Module Description
Check Updated definitions and added several new ones.
General Support for database names with special characters.
Script Improved database connection management

v 1.14.7143.19426 23 Jul 2019

Module Description
Optimize Errors running individual checks won't cause the entire analysis to fail (although errors such as failure to connect will still cause it to abort).
General Improved the handling of timeouts.
Optimize Suggest converting unique indexes to clustered if no primary key or identity columns are found.
Optimize Resolved a bug where included columns could be scripted for clustered indexes.
Optimize Resolved a bug where suggested indexes are considered when checking for duplicate indexes.
Optimize Check for orphaned distributed transactions and provide KILL SQL.
Optimize Suggest converting identity columns found on heaps to be clustered primary keys.
Optimize A summary of the analysis results is displayed before the results themselves. Users wanting to ignore the summary can turn this off via the Optimize page on the Settings dialog.

v 1.14.7114.19663 24 Jun 2019

Module Description
Optimize Removed the clustered / non-clustered usage comparison check.
Optimize Fixed a bug with duplicate columns names when comparing indexes.
Optimize Performance improvements.
Optimize Removed 'Ease of Use' checks from the default options.
Optimize Halved the number of threads used when running a check.
Optimize Index naming convention issues are now flagged as Low Priority rather than Best Practice.
Optimize Resolved a bug when decimal \ numeric is used as an identity column.

v 1.14.7061.20468 02 May 2019

Module Description
Optimize Resolved an issue with divide by zero.
Optimize Resolved an issue with checking TF 1117 & 1118.

v 1.14.7055.25997 27 Apr 2019

Module Description
General Internet proxy support for license management.
Compare The System Information comparison now compares Linux OS info.
Optimize Advise functionality has been renamed to Optimize.
Check Health Check functionality has been separated out into it's own tab.
Optimize A bug in the checking of SQL Error Logs has been fixed.
Optimize If failed login attempts are found, far more useful information it output about the failed attempts.
Optimize Supporting articles have been added for all checks that were previously missing them.
Optimize New check to see if DBCC CHECKDB has been run recently.
Optimize New check on database recovery model.
Optimize New check for identity columns reaching their maximum.
Optimize New check for empty file groups.
Optimize New check to detect disabled check constraints.
Optimize New check to detect disabled foreign key constraints.
Optimize New check to detect if the Query Store isn't enabled, has failed or is close to failing.
Optimize New check to detect if transaction log hasn't been backed up (if in FULL recovery model).
Optimize New check to detect if 'sa' user hasn't been renamed.
Optimize Updated UI for choosing the checks to run, with clearer top-level categorisation (performance, security, stability, data integrity and ease of use).
Optimize New settings pages for controlling what checks are run and for customising parameters for various checks (e.g. how recent a transaction log backup should have been).
Optimize New check to detect data and log files on the same volume.
General Server tag tree widths are now consistent throughout the application.
Check Health Checks now handle errors due to Availability Groups better, no longer showing them as outright errors.
Optimize The internet-based content panel on the bottom right of the results page will not be displayed if no internet connection is detected.
General The server search field has been moved to a consistent location (above the tag tree) and will support regular expressions for more powerful searching.
General The application will display a "What's Changed" button on the main title bar after an update, giving quick access to the recent change list.
Optimize When choosing to ignore a finding, it's now possible to permanently ignore that finding on that server, so it won't come up again (although it can be found again by turning on the filter option to display ignored findings).
Optimize Trial length now extended to 14 days.

v 1.13.6992.30226 22 Feb 2019

Module Description
Compare Compare results now default to grid view, rather than the summary graphs.
General Registration prompt removed from application.

v 1.13.6988.34256 18 Feb 2019

Module Description
Script Executing scripts with lots of batches (i.e. GO statements) is now much faster (25 times faster in some cases).
Script If a SQL connection is lost or closed while a query is executing, the UI correctly detects this and displays it.
Script Progress area below results area now shows count of batches and which batch is currently executing.
Script The results area will update as results are returned, so it's clear that long-running queries are progressing.
Script The messages tab will always be selected if any errors occurred.
Script SQL validation (Ctrl+F5) is much improved and will detect more errors.

v 1.13.6961.39706 23 Jan 2019

Module Description
Advise Bug fix where instance properties were not captured if a certain combination of options was selected.

v 1.13.6927.21366 19 Dec 2018

Module Description
General A small painting bug on the main Ribbon has been fixed.
Advise A bug that stopped queries running in Advise, if a query was stopped and quickly restarted, has been fixed.
Compare Compare will no longer flag errors due to non-readable AG nodes as differences.

v 1.13.6922.30844 15 Dec 2018

Module Description
Compare Added right-click 'Take Snapshot' option to servers table on Compare view.
Compare The UI for loading comparison snapshots has been re-written so it's much clearer what you can do with them.
Advise A bug in Advise that meant database file sizes weren't always checked has been fixed.
Advise TempDB is now shown as a separate node in the Advise results view, under the instance node, so all Temp DB issues can easily be seen together.
Advise Quote characters can be escaped in Health Check scripts by using a backslash character.

v 1.12.6900.20402 22 Nov 2018

Module Description
Advise Resolved an issue with an incorrect script for addressing low free space.
Advise Fixed a bug with sizing small databases.
Estate Tag tree on Estate view now has check boxes for bulk-selecting servers by tag.
Advise Primary keys are never highlighted as unused indexes.
Advise Added PageCount to index information dialog.
General Fixed bug with About dialog failing to load.
Script Bug fix when refreshing the list of database names in Script.
Script The Compare tab now has a new 'Snapshot' button to allow immediately capturing a snapshot to file for later viewing.

v 1.12.6863.24060 16 Oct 2018

Module Description
Script Fixed a bug where the Run button didn't work.

v 1.12.6862.30751 15 Oct 2018

Module Description
Advise Fixed a bug where Advise results didn't resize or appear correctly.
Advise Fixed a bug with incorrectly displayed tempdb file counts.
General The settings dialog has been updated to clearly indicate which settings relate to the application and which relate to the profile.
Estate Updated health checks to support SQL Server 2019.
Estate New health checks for suspect pages, auto_close, unsent mail, DBCC checks, QueryStore, untrusted FKs / Constraints 8 AG delays.
Estate Updated connection test dialog to indicate progress and allow restarting the tests.
General Added F5 support throughout the application, so F5 will start an Advise analysis, start a Compare check etc.
Estate Added a Launch menu to the Estate view, with options to launch Remote Desktop and SSMS for the highlighted server.
Advise A bug handling URL clicks in Advise results has been fixed, so the linked page will now be opened in the default browser.
General Browser proxy settings are used when checking for app updates etc.
General Product update dialog, shown when a new update is available, shows changes in all versions between the current version and the new one, so if multiple versions behind, all missed changes are shown.
General Estate view shows an Aireforge logo watermark in bottom right.
Estate Update of health check definitions.

v 1.12 05 Oct 2018

Module Description
General Added support for SQL Server 2019.
Advise Check index names against pre-defined and custom naming conventions.
Advise Advise "unused index" warnings now include information about when the table was created, or the server was last restarted (whichever is more recent).

v 1.11 01 Aug 2018

Module Description
Advise Improvements to Advise UI.
Estate Display SQL build number, edition and OS name in Estate overview.
Advise Improved non-clustered index check. Suggest converting a non-clustered primary key before an identity column.
Advise Index property dialog now shows seeks, scans, lookup and fragmentation information.
Advise Check virtual log file (VLF) count.
Advise Check for suspected bad pages.
Advise Flag unused tables (no rows or reads since the instance was started).
Advise Ignore unused indexes or missing clustered indexes on empty tables.
Advise Bug fix: When checking auto update / create statistics settings.
General Bug fix: Application freezes when sending mail in offline mode.
Advise Bug fix: Ignore hypothetical indexes when checking for duplicates.
Advise Improvements to indexes being used more than clustered indexes.
General Updated application & CLI icons to dog icon.

v 1.10 01 Apr 2018

Module Description
Compare Resolved an issue with comparing SQL Agent Jobs.
Script Fixed a bug connection couldn't be established responding with a success.
Advise Improved the profiler check. Now shows the login, host and a script to kill the connection.
Advise Support for filtered indexes.
Advise Fixed a bug when checking for disabled indexes.
Compare Improved user and login checks, reducing noise for all systems and only comparing user sid if the instance is in an availability group cluster.
Advise Fix a bug with failed logins check.
General Suport for FIPS enabled systems.
Advise Updated suggested maximum memory.
Advise Bug with the Advise SQL version check has been fixed.
General Updated "in progress" UI.
Advise Several performance improvements and big fixes.
General Support for snapshot databases.
Script Performance improvements.
Advise Tuned the suggested memory for smaller systems.
Estate New Feature: Estate Health Checks (Custom and predefined).
Advise New UI for the Advise results, showing a lot more information and providing new ways to sort and filter the results.
Advise Significant performance improvements for Advise.
Compare Bug fixed where system default comparisons don't get automatically deleted.
Advise Max memory for editions is now based on buffer pool + in-memory + columnstore for supported versions.
Advise SQL suggested by the Advise module now has a button to copy the script directly into the Script module.
Estate Improved connection test now works from the ticked servers on the Estate view, rather than the highlighted ones.
Advise New check: I/O bottlenecks detected.
Advise New check: Database File Initialization Disabled.
Advise New option to ignore a specific update (not available in community edition).
Advise Check that use Backup Checksum Check as Default is enabled.
Advise Check that use Backup Compression as Default is enabled.
Advise Check that Optimize for Ad-hoc Workload is enabled.
Advise Check that remote Dedicated Admin Connections are allowed.
Advise Check that Index create memory is set to default (self-configuring).
Advise Check for instance fill factors that are not default (not 0).
Advise Fixed a bug when comparing space of data files in filegroups.
Advise Taken out painting of split pane dividers while resizing.

v 1.1 01 Aug 2017

Module Description
General Improvements to almost every screen and dialog.
Advise Added partial support for column store indexes.
Advise Ignore fragmented indexes now based on pages rather than rows. Defaults to Microsoft recommended value of 1,000 pages.
Advise Warn if database owner does not exist & suggest fix.
Advise Added suggested fix SQL when (auto close enabled, auto shrink enabled, auto create/update statistics disabled, page verify not CHECKSUM).
Advise Warn if auto update statistics is disabled.
Advise Warn if data files are larger than 10GB and have more than 90% unused.
Advise Changed cost threshold for parallelism check to alert if < 15 but still suggest 30.
Advise Changed the suggested size for new tempdb files to total space / existing files * number of suggested files.
Advise Added fix SQL for old compatibility modes and disclaimer about breaking changes.
General Professional Edition is now unlimited for Compare and Script.
General Improved error handling surrounding the licencing.
Script Fixed bug when displaying varbinary.
Script Script is now Free (limited to 200 servers but contact us if you need more).
Compare Compare is now Free (limited to 200 servers but contact us if you need more).
Advise Fixed a bug with indexes in filegroups other than primary.
Advise Improvements to auto growth check.
Compare Updated comparisons definition.
Advise Fixed an issue with memory optimized filegroups.
CLI Security fix for the CLI module
Advise Fixed a bug when checking backup histories.
Script Fixed a bug when running batch queries in Script.
General Fixed a bug when discovering SQL Server 2017 servers.
General Now installs to program files rather than program files (x86).
Advise Improvements and bug fix for database file auto growth suggestions.
Advise Database auto growth flags if less than 5% percent growth or MB but still recommend 10%.
Script Script module introduced. This new tab allows running SQL against multiple servers at once, with various options on how the results are combined (or not).
General User interface rewritten to allow themes to be applied. Current theme can be selected via the User Interface page in the Settings dialog.
Advise Advise results now have an Explain link next to them, taking you to a page in the Aireforge knowledge-base, giving more details on the warning.
Advise Resolved a bug with auto growth checks for database files < 256MB.

v 1.0 01 Mar 2017

Module Description
Advise Intermittent painting issue resolved on the results screen.
Advise Advise now checks for low physical memory availability.
Compare Removed size from database files, leaving size_mb.
Advise Resolved an issue with getting physical index stats on 2008 & R2.
Advise Improvements to resolve painting issues and improve the performance.
Advise Advise checks for old backup information that should be cleared down.
General Resolved non-HTTPS font issue with changelog page.
General It's now possible to quickly add servers to the Estate from a free-text list of addresses, using the new Import -> Text option.
General External changes to profiles and comparisons are now detected, and the user is given the opportunity to load the changed files.
Advise Advise now checks for sys.configuration records where the value_in_use differs from the value.
Tune Renamed Tune to Advise.
Tune Resolved a performance issue with Tune whilst obtaining index fragmentation information.
Tune Fixed a bug where filestream files were counted as log files.
Tune We no longer check growth settings for filestream data files.
Tune Fixed a database check for 2012 and before.
Tune Fixed a bug with DROP USER scripts.
Tune Fixed a bug with incorrect MAXDOP recommendations.
Tune Ability to analyze instances.
Tune Ability to analyze databases.
General Automatic version checking now delayed slightly after app start up, so it won't happen before the first form is shown.
General When adding a SQL Server instance on the local host, it will automatically test all connection protocols.
General Changed all web links to HTTPS.
Tune In-memory tables now ignored completely (until we decide how to handle them correctly).
General Server tags can now be colored (e.g. red for Production, green for Test, etc.).
General The Delete button on the login dialog will now correctly delete the selected profile.
Compare Added support for SQL Server 2017.
General Fixed a website problem with the host comparison updates.
Tune The View SQL dialog now has a Copy to clipboard button to copy the entire script.
Tune The Tune UI has been redesigned to present new instance and database tuning options, which check things like memory settings and data files.
Tune A bug where Tune recommended making an index unique when it shouldn't have, has been fixed.
General The License Key will no longer be shown on the Licensing dialog.
General Error handling around blank temporary files.

v 0.9 01 Jan 2016

Module Description
Tune The first functionality in the Tune module is now available! You can use it to analyze table schema and indexes!
Tune Index tune will no longer suggest using a disabled index over an existing non-disabled one.
Tune Index tune will suggest dropping disabled indexes.
Tune Index tune will suggest dropping and recreating indexes with additional included columns, to make other indexes redundant.
Tune Schema tune will no longer suggest renaming bit columns.
Tune There's a new Custom button on the Tune tab, allowing more control over the tune analysis.
Tune Tune analysis will now scale the number of threads used according to the number of cores on the PC, rather than using a fixed number of threads.
Estate Drag and drop in the tag configuration dialog works again.
Estate New profiles will automatically have four tags created by default, so new users have something to start from.
Estate The Delete key will delete the selected servers (with a confirmation question first).
Estate A new "Add Server..." option is now available on the right-click of the tag tree.
Estate When adding an Azure SQL database, the network protocol option now disables named pipes and shared memory as TCP/IP is the only option.
Estate When adding a new server, it's now possible to set the time-out and SSL encryption settings.
Estate When adding a new server and specifying an overriding connection string, the connection string is validated when the OK is pressed.
Estate When adding a new server, it's possible to set a color against it. This color is then shown everywhere that server is.
Estate A display bug, where renaming a tag didn't update the tags column in the Estate view, has been fixed.
Compare Selecting a comparison category from the results summary will now correctly update the category filter combo box.
Compare Bugs in both hiding comparison results and suppressing comparison warnings are fixed.
Compare Comparisons will now scale the number of threads used according to the number of cores on the PC, rather than using a fixed number of threads.
Compare A new "Repeat" button on the comparison results tab allows re-running the comparison again with all the same details.
Compare If a comparison fails, two new buttons are shown to allow retrying the comparison or running again but with just the servers that were successful.
Compare Comparison tabs are added in order now, so Comparison 2 is to the right of Comparison 1 etc.
Compare The button to load a past snapshot now has a drop down, listing recently saved snapshots.
Compare Comparison file updates are now downloaded from the Aireforge web server, so comparison updates no longer require product releases.
Compare Custom comparisons can be configured to ensure a value is in or outside of a specific range.
Compare Custom comparisons can be configured to ensure a value is equal or near another value in the same result set (e.g. to ensure a configuration value_in_use is the same as the value).
Compare New right-click menu on comparisons table on the Compare tab, allowing easy editing and creation of comparisons.
Compare When editing a comparison, a new "Test" button allows direct running of the query against a server and uses the result set to populate the columns table.
Compare A bug that prevented the mouse wheel working on the comparison results combo box filter is fixed.
General Buttons for connecting to Aireforge Server have been removed.
General Buttons for Twitter and LinkedIn have been added to the Help tab.
General Log file naming has been changed to include the date and time in the file name itself.
General The login window has a checkbox to make it automatically log in with the same profile each time.
General New checkbox on the Settings dialog to disable automatic version checking, for use in environments without internet access.
General Application updates are downloaded in the application itself, prompting for a restart when complete.
General A bug that caused an exception when closing the app has been fixed.