Innovation + Product Development

When we do the automatic testing for web service, we need the JDBC Steps in SoupUI so that we can confirm some value in the Database. How to add the JDBC Steps in SoupUI   a. Adding the file ojdbc14.jar in the folder: C:\Program Files\eviware\soapUI-3.6\lib   b. Adding the following string in the Configuration session: […]

This is Part V in a multi-part series. Part I introduced the concept of analytically measuring the performance of delivery teams. In Part II – We talked about how Agile practices enhance our ability to measure more accurately and more often. Part III defined a system model for defining 3 dimensions of performance (Predictability, Quality […]

Recently one of the projects that I was involved in was finished. The testing was blocked at the end phase, and the cost was almost exhausted even though the testing had not been finished when testers were rolled off. People always talk about quality, and most people agree that quality should be the most important […]

We have team members who attended a Boot Camp where they learned skills such as how to write a unit test.  They are very smart and created a lot of unit tests for their code. We use unit test coverage rates to judge the quality of unit tests. The boot camp team got a 87.5% […]

Sometimes we need to calculate one column with cumulative value based on other columns value and value from previous row, here is one case Column BUSINESS_DAY_OF_MONTH should have a cumulative value of business day count in one month. You might have some sql script to get this value, but here is a simple way in […]

This is Part IV in a multi-part series. In Part I – We introduced the concept of analytically measuring the performance of delivery teams. In Part II – We talked about how Agile practices enhance our ability to measure more accurately and more often. In Part III – We introduced a system model for defining […]

Although agile software development methodologies value customer collaboration more than contract negotiations, it does not mean that contracting is not important. In fact, proper contracting is critical to the success of a project (especially for multi-shore projects). Many projects become “Death March” because of inappropriate contracting. If we look into the business of software offshore […]

You want to insert an XML payload record in DB table, but the content for that column is too long and you can’t insert it into table. The traditional SQL: “insert into table (field1) values (‘yourxml’)” will fail because of the long characters. How do you handle this situation? Scenario:  client requires to insert a XSLT/XQuery […]

Step 1. Create and configure the Excel worksheet. In Microsoft Excel do the following: Select the required rows to be read into PowerCenter. Select Insert > Name > Define (Formulas > Name Manager in Excel 2007). Enter a name for the range. Click OK. Save the worksheet.

SQL development varies from case to case when it use different database such as Oracle, DB2 and MSSQL. Today we’d like to take “sub-query” as an example to explain the differences. For example, we want to calculate rate, Oracle support two ways:

This is Part III in a multi-part series. In Part I – We introduced the concept of analytically measuring the performance of delivery teams. In Part II – We talked about how Agile practices enhance our ability to measure more accurately and more often. In this part, we’ll talk about “Which Dimensions are Most Important […]

It’s very common nowadays to use multiple tools in our development environment, we use: Subversion for version control Sonar for static analysis Selenium for web testing automation Hudson for continuous integration Maven for build management etc.