Axial SQL Tools 3.6 | SSMS 20 VSIX

This is the final release of SSMS 20 Addin (moving to SSMS 21 for future updates).
Various minor bug fixes and enhancements to improve stability and usability.

Full Changelog: 3.4...3.6

Axial SQL Tools 3.4 | SSMS 18/19/20 VSIX

This update brings several enhancements and new tools:

• SSMS 20 Support:

  • additional SQL connections will be made with ecnryption enabled

• Server Health Dashboard Enhancements:

  • a new graph to display volume(s) utilization
  • a new graph to display wait stats (still an experiment)

• Query Execution Status Bar Enhancement:

  • execution time now includes milliseconds

Axial SQL Tools 3.3 | SSMS 18/19 VSIX

This update brings several enhancements and new tools:

• Improved TSQL Code Formatting:

  • For more details, check out Wiki on TSQL Code Formatting.

• Export Grid to Email: - Wiki: Export Grid to Email.

  • You can now directly send emails from SQL Server Database Mail without setting up an SMTP settings.
  • The tool remembers up to 30 email addresses you've used before for faster access.

• Server Health Dashboard Enhancements: - Wiki: Server Health Dashboard.

  • Added quick access links for common server queries like blocking, transaction log status, and sp_WhoIsActive.
  • Introduced a new feature to visualize the backup history with a graph.
  • Same graph concept to track the history of agent jobs.

• Query Library Expansion:

  • I've added a variety of new queries to the Query Library to help you manage your databases more effectively.

[2/26/2024] - Newtonsoft.Json.dll was missing because of the VS2017 bug. Uploaded new binaries with the DLL included.

Axial SQL Tools 3.2 | SSMS 18/19 VSIX

Significant progress has been made through various ideas and experiments.

• Both SSMS 18 and 19 versions are supported.
• New open transaction indicator.
• Numeric values in the grid are aligned to the right.
• Added a few incremental metrics to the dashboard and the ability to blink the title when something is wrong, along with a quick link to the blocking query.
• Improved Excel export.
• New quick data transfer between open connections.

More or less tested it on a clean system. Make sure to unlock the DLL if your system has blocked it.

Axial SQL Tools 3.1 | SSMS 19 VSIX

• added Server Health Dashboard feature
• added Grid to Email feature
• SSMS 19 only. Won't be able to compile it for SSMS 18 for now.
• made it more stable

AxialSqlTools.zip

Axial SQL Tools 3.0 | SSMS 19 VSIX

This is the third version of the add-in, initially developed for personal use in 2016. The switch to C# has allowed for a new version that properly supports SSMS 19. While the list of query templates has not been compiled yet, plans are in place to add the most commonly used and helpful scripts soon.