dbForge Query Builder for SQL Server

dbForge Query Builder for SQL Server is a tool for quick creation of SQL queries and extended data management. It allows you to effortlessly create any complex queries to SQL Server databases. The main component of Query Builder is a visual diagram where you can "draw" your query. Adding tables, creating joins, or editing conditions will be as simple as several slicks of the brush.You won't be confused how to analyze and process received data the best way, using Query Builder. Now you can also create INSERT, UPDATE and DELETE queries and quickly convert SELECT query into UPDATE or DELETE with saving WHERE condition, Usability of visual expression editor is improved and the new start page is added.

Key features:

*SQL Server 2019 support

* Visual query creation

* State-of-art diagram with zooming

* Query schema window for complex queries

* Query profiler

* Undo/redo support

* Visual editing of sub-queries

* Convenient expression builder

* SQL editor with syntax coloring

* Bookmarks and text search

* Extended SQL formatting in the editor

* Automatic SQL syntax check

* Advanced management of query results

* Diagram and data printing

* Data editor with filtering

* Grouping, and sorting options

* Customizable and intuitive GUI

* One-click help system

* Query Profiler

* Query execution pane

* Compliance with the Federal Information Processing Standard (FIPS)

* Trial product activation implemented

* Greatly improved visual style of the application with high DPI support

* Connection to Microsoft Azure SQL Database by using identities in Azure Active Directory

* Live query statistics

* Wait Stats tab

* Saving/Opening execution plan files

* Table I/O

* Highlighting potentially resource-intensive statements

* Displaying clustered columnstore indexes in execution plan

* Dramatically improved data import performance

* Export/import of JSON data

* Redesigned export/import of XML data

* Preview of the generated UPDATE script in the wizard