What's New in DBArtisan 2016

From DBArtisan
Jump to: navigation, search

Go Up to Main Page

PostgreSQL Object Management

Object Wizards/Editors

A Wizard and an Editor for Types have been added for PostgreSQL: Types Wizard and Types Editor.

Analyst Explorer Node

The Analyst Node of the Explorer provides shortcuts to the License-specific Analyst Series tools. These shortcuts are:

AnalystNode.png

Missing Indexes

The Missing Indexes feature analyze the system looking for Missing Indexes which, once added, would improve the performance.

DBArtisan proposes you some Indexes that can be created created after analyzing the system. You can create these Indexes by launching the Indexes Wizard (SQL Server) and directly double-clicking the selected Missing Index.

Description about how to use and access Missing Indexes is in Missing Indexes (SQL Server).

Note: Missing Indexes is only available for SQL Server.

ISQL Performance

SQL Editor includes new functionalities for SQL Server. In this new release, SQL editor provides information about the SQL statements while you are writing in the SQL Editor. This information is included in a new window as well as listed in the Error Pane. Information like Missing Indexes, Statistics, Overlapping Statistics and Recommendations are displayed in this new window. You can find more information in ISQL Performance

Performance window

PerformanceMissingIndexesTab.png

ISQL Performance listed in Error Pane

ErrorPane.png

Note: ISQL Performance only available for SQL Server.

Team Server 2016 Support

Integration of Team Server 2016 in DBArtisan has been improved. The old TeamServer Navigator has been fully integrated into the Datasource Navigator/Explorer as well as all the features only accessible from the TeamServer Navigator. For more information, see Using the Datasource Navigator/Explorer and Basic Viewing Options in the Navigator/Explorer. Notice that when logged in Team Server 2016, a node is added:

  • Saved Searches

Explorer.png

Team Server 2016 as the Data Source Catalog

DBArtisan 2016 adds the option of registering datasources from the Team Server 2016 Repository. To allow that, new options have been added to Quick Start Setup, and in Tools > Options > Datasources.

In Quick Start Setup, the import of datasources using Team Server 2016 as a catalog has been added.

QuickStartSetup.png


In Tools > Options > Datasources the possibility of selecting Team Server 2016 as the source of the catalog has also been added. For more information, see Working with Team Server 2016 as Datasource Catalog.

OptionsTeamServerCatalog.png

New Data Source Search Button

A new button for TeamServer datasource search has been added. This button is located on top of the Datasource Navigator/Explorer and it appears only when you are logged in Team Server 2016 and the Saved Searches node is selected.

NewDataSourceSearchButton.png

For more information about how to use the New Data Source Search see Searching Team Server 2016 for Datasources.

Topics

Personal tools