(Partha S) Quest Code Tester Beta was released last week. As I had pointed out in my last two entries on the tester, I have been having problems getting the Tester to run properly on Oracle 10g XE. The latest beta version 1.5 resolves these issues, and finally I was able to get it to run correctly.
Other News
On importing data from Oracle into Excel with a Visual Basic for Application macro
(René Nyffenegger) I have been playing with Excel and its Visual Basic for Application (VBA) macros recently. As much as I loathe the syntax of VBA, I do like what can be done with it. Especially, I found it quite easy to connect to an Oracle Database with ADODB, execute a select statement and impor
Monitoring the Oracle HTTP Server
(Sam Alapati) You can manage the Oracle HTTP Server through the Application Server Control, or with the help of command-line tools.
How to make MySQL replication reliable
(Xaprb) MySQL statement-based replication is widely discussed, but I haven’t seen much about how to design a replication setup for low downtime and easy administration. Statement-based replication has inherent shortcomings experienced MySQL users know to avoid, but rarely write about. This article e
What’s New in Prototype 1.5?
(Scott Raymond) The latest release of Ruby on Rails, version 1.2, was announced last week to great fanfare. But the announcement might have overshadowed news of a simultaneous release: version 1.5 of Prototype, the popular JavaScript library. Despite the synchronization and developer overlap between
OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4
(Hernando Bedoya, Jaime Gaug, James Kerl, Ser Ser NG and Jose Cardoso dos Santos) The goal of database performance tuning is to minimize the response time of your queries. It is also to optimize your server’s resources by minimizing network traffic, disk I/O, and CPU time. (pdf)
DB2 Version 8 CPU regression… my conclusions
(Willie Favero) The cry heard round the world of late has been "How much CPU is DB2 Version 8 going to use?" OK, that may be a little over the top. However, whether you call it CPU consumption, CPU regression, or simply CPU usage, this seems to be a big question on everyone’s mind today. For some, i
AJAX Test Automation
(James McCaffrey) The popularity of Web applications that use AJAX (Asynchronous JavaScript And XML) technology has increased steadily over the past year. When written correctly, AJAX can yield significant improvements in performance and user experience compared with non-AJAX Web applications. Howev
Analyze your managed .NET code with FxCop
(Tony Patton) I have never met a programmer who doesn’t make a coding mistake from time to time. Tracking down and addressing these issues can be one of the most important aspects of your job. The next time you need to analyze your managed .NET code, I recommend using Microsoft’s FxCop tool to track
Practical applications of AJAX in WebSphere Portal
(Bikramjit Naha, Brian DeLuca and Tony Efremenko) This article tells you how to use AJAX with IBM WebSphere Portal Version 5.1.3 for Multiplatforms to quickly meet a few of the basic expectations in your portlet applications that users have come to expect from using sophisticated, graphically-based