(Kimberly Floss) As someone who has worked in the database trenches for more than 15 years now, I have a terrible confession to make: I have never been really good at reading EXPLAIN plan output. Oh, I can do the basics like recognize table scans, spot Cartesian joins, and zero in on unnecessary sor
Other News
What’s New in WSE 2.0
(Aaron Skonnard) Microsoft has recently released Web Services Enhancements for Microsoft .NET (WSE) 2.0. WSE 2.0 provides extensions to the existing ASP.NET Web services framework (.asmx) as well as a standalone messaging framework that’s completely transport independent. The WSE 2.0 Technology
DB2 Data Archive Expert for z/OS: Enhancements for DB2 for z/OS V8 Support
DB2 Archive Expert for z/OS Version 1 has been enhanced in order to support the new limits of DB2 for z/OS Version 8. With the implementation of long names in DB2, larger indexes, and larger SQL statements, Data Archive Expert has undergone several changes in its panels structure and Row Filter
XML Watch: Describe open source projects with XML, Part 4
(Edd Dumbill) This installment of XML Watch concludes the development of a vocabulary for describing open source software projects, exploring the documentation, tools, and community that are required for the successful launch of the DOAP vocabulary. The steps taken are drawn from the author’s experi
DB2 UDB V8.1 ESE and high availability on AIX with HACMP 4.4.1
(Mika Nikolopoulou) High availability of your data is a must for the on-demand environment. This article takes you through a specific example of how the author set up high availability as part of a proof-of-concept demonstration of IBM DB2 Universal Database with High Availability Cluster Multi-Proc
Introduction to Oracle 10g’s New SQL Tuning Advisor
(James Koopmann) Come along and see how Oracle has helped us in alleviating the pain associated with tuning SQL. Gone are the days of staring at countless structures and statistics just attempting to tune a SQL statement. Oracle has once again given us a great tool that will assist us with manua
More UDF Back Doors
(Itzik Ben-Gan) T-SQL programmers often use user-defined functions (UDFs) to encapsulate algorithm implementations. However, several aspects of UDFs constrain programmers’ capabilities. In “UDF Back Doors” (April 2004, InstantDoc ID 41845), I discussed some UDF limitations and some back doors th
Reducing Round Trips – Working with HTML Checkboxes
(David Poole) Imagine a contacts database where we need to indicate whether or not a particular contact has a particular attribute of a dynamic list of attributes. For example our contact may be a student who has to choose a set of topics within a course. We may have a table structure similar to
Make Reports Quickly With ASP.NET and XML
(Andrew Mooney) Sometimes you need to create reports quickly. You might not always have time to format fancy reports containing graphs. Or maybe you have to create reports that do not need graphs. Reusing one ASP.NET web page you can display many reports.
What is different in XML?
One of the great benefits of XML is that it enables generalised processes to be developed that will work against any relevant XML document. For example XSLT provides a generalised transformation process. More specifically there are point-solutions for example a calculator that will add sales tax to