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.

Featured

  • Malwarebytes Affirms Other APT Attack Methods Used Besides 'Solorigate'

    Security solutions company Malwarebytes affirmed on Monday that alternative methods besides tainted SolarWinds Orion software were used in the recent "Solorigate" advanced persistent threat (APT) attacks.

  • How To Fix the Hyper-V Read Only Disk Problem

    DOS might seem like a relic now, but sometimes it's the only way to fix a problem that Windows seems ill-equipped to deal with -- like this one.

  • Microsoft Warns IT Pros on Windows Netlogon Fix Coming Next Month

    Microsoft on Thursday issued a reminder to organizations to ensure that their systems are properly patched for a "Critical"-rated Windows Netlogon vulnerability before next month's "update Tuesday" patch distribution arrives.

  • Microsoft Nudging Skype for Business Users to Teams

    Microsoft on Thursday announced some perks and prods for Skype for Business unified communications users, with the aim of moving them to the Microsoft Teams collaboration service instead.

comments powered by Disqus