What's New in DBArtisan 2016
Go Up to Main Page
- 1 PostgreSQL Object Management
- 2 Analyst Explorer Node
- 3 Missing Indexes
- 4 ISQL Performance
- 5 Team Server 2016 Support
- 6 Topics
PostgreSQL Object Management
Analyst Explorer Node
The Analyst Node of the Explorer provides shortcuts to the License-specific Analyst Series tools. These shortcuts are:
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.
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
ISQL Performance listed in Error Pane
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
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.
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.
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.
For more information about how to use the New Data Source Search see Searching Team Server 2016 for Datasources.