(Jean-Paul Lamontre) SQL Visual Explain tool, which comes with iSeries Navigator, is a very handy tool that helps you to improve the performance of your SQL statements. If you haven’t had the opportunity to try it, I highly recommend it. You can find the Visual Explain tool here. If you have used it
Other News
DDL Generation–Oracle’s Answer to Save You Time and Money
(James F. Koopmann) Oracle has once again given us what we asked for, almost. A simple way to generate the DDL for objects defined in the database.
Developing Smart Web UIs with Ajax, JSF, and ADF Faces
(Andrei Cioroianu) Asynchronous JavaScript and XML (Ajax) is a recent term for a group of mature APIs, technologies, and standards that can be used with all major browsers. Besides HTML/XHTML, CSS, JavaScript, XML, and DOM, the so-called Ajax applications use an API named XMLHttpRequest, which lets
FIX: An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1
After you apply Microsoft Windows Server 2003 Service Pack 1 (SP1), an error occurs when you try to access the Microsoft SQL Server 2000 Analysis Services performance monitor counter object.
The Power of No
(Micah Dubinko) I remember a trip to Tijuana, where on Revolución Avenue, a carved chess set caught my eye. For several minutes I gazed admiringly at it, feeling the rough texture of the carved stone pieces. It was a very special one, the shopkeeper assured me, but since he got a such a good deal on
JAX-RPC Evolves into Simpler, More Powerful JAX-WS 2.0
(John J. Yates) As of version 2.0, JAX-RPC has been renamed JAX-WS. But the change is not in name alone. JAX-WS offers simplified development, better platform and language independence, and an end to the chaotic array of earlier Java Web services frameworks. This article explores the high-level arch
Project Management 101: Creating the Right Ripple
(Steve Joubert) Most software projects fail. Only about a quarter are completely successful. About half are late and over budget and the remaining quarter just fade into oblivion. What if there was a simple way to ensure your project’s success? There is, and it’s all about starting out in the right
SQL Database Table Space Used Data as a CSV File
(Ted Bouskill) Do you have or have you ever managed a legacy SQL database that has become large and unwieldy? This tool can be executed at anytime, even as a scheduled task, to create a unique date and time stamped CSV file with a report of the table space used for each table in the database, using
User annotations in Ajax
(Greg Travis) The ability to add notes and comments to your Web site can be a powerful and attractive feature for users. This tutorial demonstrates how to implement an Asynchronous JavaScript and XML (AJAX)-based user annotation system in the form of yellow sticky notes that sit on top of regular We
Auditing and Logging Exceptions
(Sonu Chauhan) The default ASP.NET process identity for Web applications can write new records to the event log, but it does not have sufficient permissions to create new event sources.