2017-09-14 by Phil Grayson
New Advise Module and Aireforge Studio v1.0.7
What's new at Aireforge?
We're pleased to announce that Aireforge Studio is now officially live and supported. Version 1.0.7 ships with hundreds of improvements with a new UI, simpler comparisons with advanced options, 2017 support and our new tuning / best practices module; Advise. Depending on your version, the application should prompt to update after starting. If not, please download the latest version using the link below.
The new Advise module within Aireforge Studio analyses instances, databases, tables and indexes, before providing recommendations. The growing list of checks vary from best practices and naming convention violations to orphaned users and missing, duplicate or overlapping indexes.
Compare v1 & Custom Comparisons
The Compare module within Aireforge Studio performs a growing list of comparisons, which can be restricted if certain values are known to differ, such as core count or edition (e.g. Enterprise vs Developer).
Common use cases for Aireforge Studio Compare are checking production databases against staging and / or staging against test, auditing the SQL Server estate, sharing configurations with colleagues / support teams.