ApexSQL Add-ins and Spotlight-Tuning Pack Conflict in SSMS 18

Applies to

ApexSQL add-ins

Symptoms

After installing Spotlight Extensions – Tuning Pack into SQL Server Management Studio 18 (SSMS 18) on a system that already has any ApexSQL add-in installed, the Tuning Pack menu will not be shown in SSMS 18 main menu.

The same problem occurs if Spotlight Tuning Pack was installed before any ApexSQL add-ins.

ApexSQL add-ins tab options do not show in Visual Studio 2019

Applies to

ApexSQL add-ins

Symptoms

With the release of Visual Studio 2019 version 16.2, ApexSQL add-in tabs do not show options in these tabs, aka ApexSQL tabs are empty. This article explains how to find a solution (workaround) when this problem happens.

Indexes rebuild operations are not properly replicated

Applies to:

ApexSQL Log

Brief description:

Replicating “Rebuild index” DDL operation (creating a redo script) with ApexSQL Log will:

  • Create phantom insert statement in transaction log auditing results and apply them to replica
  • Report job failure when tables with no primary keys are affected

ApexSQL add-ins do not show in Visual Studio 2019

Applies to

ApexSQL add-ins

Symptoms

With the release of Visual Studio 2019, Microsoft added tags in the Extensions and Updates dialog to help quickly understand whether an extension is in Preview, is a Paid extension, or is in a Trial period. This article explains how to find the installation of ApexSQL add-ins in the latest version of Visual Studio when ApexSQL item is not available among the main menu in the host application.