Features

From SQLBWiki

SQLBrowser is a Transact-SQL tool which helps understanding, editing, debugging and documenting stored procedures.
It also has a server monitoring feature as well as a TDS capture feature.

1 Inspecting Stored Procedures
2 Editing Stored Procedures
3 Debugging Stored Procedures
4 Documenting Stored Procedures
5 Monitoring Server's Activity
6 Capturing Client Server Conversations

[edit] Inspecting Stored Procedures

SQLBrowser main objective is to help understanding complex stored procedures.

Open a stored procedure, trigger or view and understand quickly what it does by visualizing the call tree and which tables are read and updated.

Queries are shown in their own tab for inspection. Query graphs help understanding complex queries visually.

Defects are shown in a separate tab.

 The list of detected defects can be found here

When combined with the Batch Analysis Output, the dependency graph can be viewed and exported.

[edit] Editing Stored Procedures

SQLBrowser editor eases query writing by providing templates and auto-completion.

[edit] Debugging Stored Procedures

SQLBrowser includes a step-by-step debugger which allows fine tuning of queries in their execution context
Fine tuning of queries is possible while debugging
IOs are highlighted for each step
IO summary is shown at the end of the session.

[edit] Documenting Stored Procedures

SQLBrowser Batch Analysis browses entire databases and produces HTML reports with indented code, hyperlinks, and cross reference information.
This creates a central point of documentation for all developers to refer to.
Example of Sybsystemprocs HTML Output (main index)
Example of Sybsystemprocs HTML Output (sysobjects table detail)