(Peter Stromquist) I maintain and develop a database for a web application that I’ve worked on for several years now. The application and the database have evolved significantly, and as things got larger and more complex, I’ve had to employ more advanced techniques and tools to perform database upda
Author: SSWUG Research
Muse and WEF eases event reporting
(Dan Jemiolo) The Web Services Distributed Management (WSDM) Event Format (WEF) is an OASIS standard that describes how to serialize events related to systems management in XML. The standard goes into detail about required values, optional values, and the semantics of both, but it offers no instruct
Add Flexible Sort Capabilities to ListView Controls
(Rod Stephens) I use the ListView control a lot. Not to display large or small icon views, which are attractive but information-sparse. Instead, I tend to use it to display a detail view similar to the one shown on the right half of Windows Explorer when you choose “Details” from the View menu or th
Oracle Clusterware install: ‘Invalid parameters, or failed to bring up VIP’ after ‘interface is not public’
(Christo Kutrovsky) Allow me to guess the sequence of events that brought you to this blog, possibly via google. –You just installed the Oracle 10g clusterware –You just ran root.sh and got an error: The given interface(s), “eth0” is not public. Public interfaces should be used to configu
SelectViews: Kimberly Tripp, Paul Randal join us for a wide-ranging interview.
Video Programming for IT Professionals
Introducing MySQL Table Maintainer
(Xaprb) MySQL Table Maintainer is a new utility to help you run table maintenance commands (ANALYZE, CHECK, OPTIMIZE, REPAIR) on your MySQL tables. It’s part of the MySQL toolkit.
So, when did that row last get changed?
(Willie Favero) Do you have a need to know when a row was last changed or inserted? Would you like to find out using a feature of SQL and have everything to track a last changed just happen automatically. If you do, then does DB2 9 for z/OS have another cool little feature for you. Here are a couple
Transform and integrate data using WebSphere DataStage XML and Web services packs
(Li Chen, Xiong Xiong and DaWei Zhang) IBM WebSphere DataStage XML and Web services packs are components of DataStage that help to deliver fast data integration solutions when XML and Web services are involved. Explore the main functions and operations of the DataStage Web Services and XML packs. Le
SQL Server XML Cribsheet
(Robyn Page) This is written with the modest ambition of providing a brief overview of XML as it now exists in SQL Server, and the reasons for its presence. It is designed to supplement articles such as Beginning SQL Server 2005 XML Programming.
Generate an XML Document from an Object Model with JAXB 2
(Antonio Goncalves) Java offers various ways to manipulate XML, including the following: –Use simple file I/O or javax.xml.stream.XmlStreamWriter. –Use XML serialization with java.beans.XMLEncoder, which generates an XML representation of a Java Bean in the same way ObjectOutputStream can be