(Scott Stephens) In an Oracle database, DBAs often look for tablespaces that are about to run out of space and either add a new datafile or remove old data so applications don’t fail with space allocation errors. I thought it would be interesting to apply treemaps to this problem. (R)
Other News
Web services programming tips and tricks: Roundtrip issues in Java coding conventions
(Russell Butek and Richard Scheuerle, Jr.) Java APIs for XML-Based Remote Procedure Call’s (JAX-RPC’s) Java-to-WSDL/WSDL-to-Java mapping rules do not try to preserve Java constructs during roundtripping. Many constructs are preserved, but not all. This tip describes, in particular, why following Jav
Working with triggers
(Susan Lawson) A trigger is a set of actions that will be executed when a defined event occurs. These are known as active triggers. The triggering events can be the following SQL statements: –INSERT –UPDATE –DELETE (R)
Identify the ‘blockers’ and the ‘waiters’
(Wolfgang genser) Do you want to know what are the blockers and what are the waiters? This SQL script was tested on 8i and 9i but was originally test on 7.3.4. It is very helpful in determining what is holding a lock and what is waiting for it. (R)(script)
DB2 V8 Application Development cert prep, Part 3 of 7: Embedded SQL programming
(Roger Sanders) This tutorial introduces you to embedded SQL programming and walks you through the basic steps of constructing an embedded SQL application. The tutorial also introduces you to the process used to convert one or more high-level programming language source code files containing embedde
Mapping HTML to XML
(Jeffrey Boltz) On a recent project, I found myself with a restrictive set of requirements. I needed to read an XML document with no prior knowledge of the XML, and send it to a JavaServer Page (JSP) to be rendered. The resulting HTML page would be an input form that needed to post back to the servl
Maximize the Potential of DB2 through Effective Space Management
Often overlooked, space management can have just as great an impact on users as a poorly tuned SQL statement or improperly configured database. DB2 ultimately relies on disk to record data stored within the database, so it is important to understand and take care of the space structures in DB2.
Importing flatfile data to MSSQL table
(Alok Vyas) This script is used to read the data from a flat file and then populate it into the database table. (script)
Understanding Yukon Schema Separation
Well it has finally arrived, at least in the Beta version. Microsoft’s long awaited latest version of it’s SQL Server product has arrived in Beta version and holds promise to be a major and successful revision of this fine product. I have had the Beta version for a few months now and one of the new
Yukon Passwords
(Randy Dyess) Among the changes brought to you by the next version of SQL Server is the ability to tie SQL Server login passwords into the Windows 2003 local policy for passwords. This ability allows SQL Server login passwords to enjoy the same complexity and expiration policies long associated with