Devart Introduces dbForge Studio for SQL Server 4.0 with T-SQL Code Analyzer
Devart announces the release of dbForge Studio for SQL Server, v4.0. The new version introduces new general features:
T-SQL Code Analyzer
T-SQL Code Analyzer is a code analyzing utility that can identify possible defects and check T-SQL code for compliance with best practices. To fine tune the T-SQL analysis process you can create code analysis profiles and edit them according to your needs.
Visual Index Editor
New individual editors for each type of indexes:
- Primary XML
- Secondary XML
- Nonclustered columnstore index
Custom mapping for objects by their names
While comparing database schemas you can manually connect objects that that do not have identical names to map them. Objects mapping even allows you to compare tables with different names in different database types.
Server Events Profiler
SQL Server Profiler is a GUI to SQL Trace for monitoring an instance of the SQL Server Engine. By using SQL Server Profiler you can:
- Create a trace
- Watch the trace results as the trace runs
- Store the trace results in a table
- Start, stop, pause, and modify the trace results as necessary
The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.
The application performance has been significantly improved. Now it supports Windows 10 and works faster when executing a query, opening a table, designing a diagram, and building a query in the Query Builder.
dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. The tool will help SQL developers to manage databases, speed up routine tasks, as well, as to make complex database changes.