SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant version 12.3 released

 
This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant version 12.3 released
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post SQL Assistant version 12.3 released Reply with quote
Short introduction
There are multiple new exciting features in version 12.3. The query execution plans have been significantly modernized. They are now available in multiple formats including graphical plan diagrams with customizable layouts in addition to tree based and raw plan versions in JSON, XML, tabular, and text formats. Additional plan statistics and database engine warnings have been added to plans where they are supported by database engines. The new Query Store Explorer for SQL Server, ASH and AWR Explorers for Oracle enable you to browse explore historical database performance, compare and analyze changes over time, identify applications and queries with steadily deteriorating performance. Below are more details on what's new in this maintenance release.

New major features and significant enhancements
1. Query execution plan diagrams with customizable layouts.
2. New Connection Organizer - if you deal with many databases, this is for you, to help you group and organize your database connections and to find them faster.
3. New Bookmarks pane for bookmark lovers, so you can see all visual bookmarks with text previews at a glance.
4. Document manager metadata is now stored in SQLite database instead of XML files. Searches for historical documents are now faster, and a longer document change history can be supported. Saving documents is faster too, reliving you from a need to periodically purge the documents repository folder to speed up file access.
5. Code Visualizer enhancement - Upsert operation is represented as a compound DML operation with conditional IF blocks and multiple logical operations instead of a single statement.
6. Database Modeling enhancement - multiple model diagrams for the same database can be created and stored in the same project file.
7. Application Data Lineage enhancements - syntax highlighting for all supported file types.
8. Multiple enhancements in SQL Assistant SQL Editor (Pro Edition), including new multi-row tabbed interface, sticky tabs, and more.
9. SQL Intellisense enhancements - better handling of keywords that are not reserved keywords.
10. Updated Object Explorer add-on for the latest SQL Server Management Studio version 19.0.2.

Database management enhancements and new features
11. SQL Server - Query Store Explorer, and historical query performance reports with graphical query plan comparison and more.
12. Oracle - Active Session History Explorer with historical resource usage reports by application and users.
13. Oracle - Automatic Workload Repository Explorer, and historical query performance reports with graphical query plan comparison and more.
14. Oracle - Enhancements in the graphical Table Properties dialogs, supporting management of partitioned indexes.
15. SQLite - Improved graphical explain plan.
16. Snowflake - Compare Jobs feature can be used with Snowflake and compare Snowflake tasks and their properties across databases.
17. Snowflake - Support for latest Snowflake features, added graphical management of Database Roles and Alerts, improved Password Policy, Account management.
18. PostgreSQL - Client tools updated to the latest version 15, to support latest PostgreSQL features.
19. PostgreSQL - Performance dashboard can be now used for monitoring PostgreSQL logical replication.
20. Amazon Redshift - Graphical management of materialized views.
21. MariaDB and MySQL - Much improved query plan presentations, and yet there is more coming soon in the next release.

Miscellaneous
22. A number of other minor improvements and bug fixes.


Here is a link to the list of changes in the previous 12.2 maintenance release
and the cumulative What's new page describing changes in all version 12.x releases.
Tue May 02, 2023 11:55 pm View user's profile Send private message
Display posts from previous:    
This topic is locked: you cannot edit posts or make replies.    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.