Product Reviews

Debugging SQL

DevPartner DB might soon become your SQL toolbox fave.

DevPartner DB provides a standalone environment for testing SQL Server 7.0 and 2000 stored procedures and triggers. It includes a lot of features that are missing from the basic SQL Server tools, including check in/check out, private workspaces to organize the objects you're working with, and a debugger that can single step, breakpoint, and more.

The core of the product is its debugging capabilities. You can launch a stored procedure from the tool's UI, or you can catch the execution from an application and debug when it's been called with actual data. You can also edit variables on the fly if you'd like to experiment with validation or boundary condition issues.

DevPartner DB also includes some performance monitoring tools. You can keep track of locks that are blocking stored procedures. You can also profile performance right down to the level of individual lines of T-SQL code. Combined with the native query plan tools, this gives you a fast way to home in on trouble spots in your application's database.

I also liked the GREP search utility that's integrated with the product. You can search through data, but you can also search through code. For example, if you have a complexly-nested set of stored procedures, you can search to find out which ones use a particular temporary table or call another SP.

Overall, DevPartner DB seems to be a fine tool if your focus is on SQL Server development. Many of its capabilities can be duplicated by a database project in Visual Studio .NET (though the integrated profiling and user-definable project trees are among the features that would be hard to copy) so this might not be the best choice if you only do occasional database work. But as a data-oriented developer I'd love to have it in my toolbox.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

comments powered by Disqus

Reader Comments:

Mon, Dec 30, 2002 Spanky Chicago

DevPartnerDB has no comparable competitor. We've looked and could not find a better debugger. The app hookup alone justified our purchase.

Thu, Dec 26, 2002 Anonymous Anonymous

External Hook is worth it's wieght in gold!

Wed, Dec 25, 2002 Diwakar Bangalore

It is a very powerful degugging tool for stored procedures

Tue, Dec 24, 2002 Anonymous Anonymous

The best debugging/developing tool for databases/stored procedures

Mon, Dec 23, 2002 ume milwaukee

Usefull tool

Mon, Dec 23, 2002 Anonymous Anonymous

Excellent

Fri, Dec 20, 2002 Anonymous Anonymous

DevPartnerDB for SQL Server 4.1 is a deverloper's dream for debugging stored procedures!

Add Your Comment Now:

Your Name:(optional)
Your Email:(optional)
Your Location:(optional)
Comment:
Please type the letters/numbers you see above

Redmond Tech Watch

Sign up for our newsletter.

I agree to this site's Privacy Policy.