Visual Expert Articles Published in 2019

A new macro - ‘Slowest SQLs using this table’ is available in Visual Expert 2019 to find out which SQL queries are taking longer to execute.

Visual Expert 2019 introduces a ‘Search’ field in the ‘Open Project’ window to find/filter projects from the list.

Visual Expert now lets you discover the synonyms created for tables or other database objects.

Visual Expert can find all dependencies to dll and dll functions, from a PB application.

Visual Expert detects all kind of dependency on your tables, whether it’s a query embedded in the code, a view built on top of it, a trigger related to this table, etc.

Read this tutorial and learn how to run Visual Expert from command line.

Visual Expert can analyze CRUD operations in your PowerBuilder, Oracle and SQL Server code (Create, Read, Update, Delete).

Developers and DBAs can now create a Visual Expert project analyzing several SQL Server databases together.

Visual Expert 2019 now supports PowerBuilder 2019 and this applies to all the tools included in the Visual Expert toolbox.

Visual Expert can track calls from PowerBuilder to web services from an entire PowerBuilder application, a selection of PBLs and a selection of PB objects.

Some features are designed to list tables in the Visual Expert User Interface.

Visual Expert 2019 adds the possibility to generate a CRUD matrix for a selection of objects (instead of starting from a selection of tables).

Visual Expert 2019 highlights the references to web services at instruction level in the PowerBuilder code.

To support them, we developed a series of optimizations for navigating faster in big volumes of code.
They will improve the response time when displaying large results in the VE UI.

Visual Expert 2019 introduces a new set of features to help analyze and improve the performances of your database code (procedures, functions, triggers, queries…).