Channels ▼
RSS

Jolt Awards

Jolts 2007: Database


Jolt Winner

Visual Studio 2005 Team Edition for Database Professionals
Microsoft Corporation

Matt Nunn, Group Product Manager

One of the notorious challenges in enterprise development is managing the testing of programs that access databases. Likewise, making sure that changes to database schema have been properly implemented. What makes Visual Studio Team Edition for Database Professionals jolting? Its name says it all. It's for Database professionals, and what Microsoft has done is to offer development-level functionality to DBAs. Add to this support for agile/evolutionary database development, and this product jettisoned to the head of the pack.

Microsoft Visual Studio 2005 Team Edition for Database Professionals makes both the testing and management of database processes much easier by providing key tools. These include: tools for automating testing with support for full unit testing of database applications running on Microsoft SQL Server; tools for managing and propagating schema changes, such as renames of tables, columns, and stored procedures; and software instruments for integrating the function of the database manager into the development cycle. This last feature continues MicrosoftÕs special emphasis in the Team Edition suite of products, which is to make sure solutions are designed correctly for the hardware and software that support them at deployment time. There is no doubt that as Microsoft continues to establish its presence in the data center, well thought-out tools such as Visual Studio 2005 Team Edition for Database Professionals will lead the way, and make other vendors very nervous. Expect others to start to hurriedly catch up.

-- Andrew Binstock

Productivity Award

Coral8 Engine
Coral8

Coral8 has created one of those types of technology products that has the potential to dramatically alter the mindset of future application architecture design, similar to the way system virtualization forever changed the data center. The company has codified the function of Complex Event Processing (CEP) into their software engine. CEP is an advanced technology approach to real-time high transaction monitoring most often associated with security oversight but also employed for vertical market high-speed data analysis and context capture as well as event-pattern detection and business-process monitoring. Coral8 has created their Continuous Computation Language (CCL), which uses correlation, aggregation, and pattern-matching syntax for CEP application construction. CCL module deployment is fast and continuous in that adding new apps and rules to the Coral8 Engine does not require offline loading/instantiation. As a fellow Jolt judge commented during our evaluation of the product, "Complex Event Processing is new wave. Coral8 is one of the leaders."

--Mike Riley

Productivity Award

dbdeploy
ThoughtWorks

Agile consultant agency Thoughtworks is known more for its Fortune 500 client list and its agile proclamations than its contributions to the open-source community, which is why its donation by Thoughtworks employees Nick Ashley, Graham Tackley, and Sam Newman of its Java-based dbDeploy database refactoring toolkit is that much more notable. The key to dbDeploy's power is its continuous database integration with project source code changes. Planting the dbDeploy jar files within a db subfolder within your source code managed project, and creating a schema version table via the bundled Microsoft SQL, Oracle, MySQL, and Sybase database scripts is all the prep work needed to start using the tool. Delta SQL scripts can be applied to database structural changes made just like source code changes are, and updated in a repository. This approach allows granular schema changes to be tracked and, if necessary, forked to match the very source code that may be used to access that new database layout.

--Mike Riley

Productivity Award

SQL Refactor
Red Gate Software

Virtually every database developer spends at least part of their time modifying and managing code written by someone else. This inglorious, often time consuming and frustrating task is now made easier by a collection of 11 refactoring tools in SQL Refactor, an add-in for Management Studio, providing a range of functions from cleaning up code formatting to major schema refactorings, aiding the SQL Server developers and DBAs to more effectively deal with legacy code, improve the overall design and maintainability of their database applications, and save time.

Among the useful features of SQL Refactor are: the reformatting of T-SQL scripts; renaming functions, views, stored procedures and tables and updating all references to these renames objects; splitting tables into two tables, again updating all references; easily creating new stored procedures; finding unused variables and parametersÉand the list goes on. As one judge noted, SQL Refactor "owns the database refactoring tool market."

--Peter Westerman


Related Reading


More Insights






Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

 
Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.
 

Jolt Awards Video