(James F. Koopmann) Concerned about looking at statistics within Oracle? You should take a quick look at Oracles’ new method of turning collections on or off.
Author: SSWUG Research
Uniform Page Size in 8.2.2
(Chris Eaton) As you may be aware, DB2 has supported multiple page sizes within the same database for years. As well DB2 supports up to 4096 buffer pools where each buffer pool can be of any valid page size (4k, 8k, 16k or 32k). This is in contrast to other vendors that only allow one buffer pool pe
Primary Keyvil, Part II
(Josh Berkus) What follows are a number of reasons people have given me, on IRC and the PostgreSQL.org mailing lists, for using autonumber keys. Some of them are “good” reasons which demonstrate and understanding of the costs and benefits. Others are “bad” reasons based on sloppy thinking or lack of
Stored procedure: Easily filter for SQL Server connections
(Brian Walker) This tip continues the system stored procedure series with a routine to list information about SQL Server connections or perform actions for selected connections. (R)
Using Apache-Style HTTP Authentication on IIS
(Ziran Sun) Have you ever wished you could easily set up password protected areas of your web site without creating system user accounts? What about moving a password protected website from Apache to IIS? This article examines a free product that makes both of these tasks amazingly simple.
Simple DOM Access
(David Nishimoto) The Simple DOM Access (SDA) provide a very abstract perspective for interacting with an xml structure. The xml structure only contains elements named “node”. Creating an xml structure with only node elements provides for easy search capabilities when using the selectSingleNode and
Create XML Easily with FOR XML PATH
(Jerry Dixon) SQL Server 2005 is now here, and with it comes a new XML data type and support for the new XQuery language. XML can now be stored directly in the database, queried, and even edited in place. In addition, the existing creation and consumption capabilities from SQL 2000 have been enhance
IBM WebSphere Developer Technical Journal: Leverage IBM Express Runtime to develop and deploy complete software solutions
(Lim Sham Sham and Tan Eng Kian) For independent software vendors (ISVs) and their customers, there is more to a solution than just the application. A complete solution includes an application, but it’s an application that is integrated with the middleware components that enable the application to w
Log DB2 UDB stored procedure messages
(Vikram S. Khatri) This article presents a logging framework that you can use with IBM DB2 Universal Database (DB2 UDB) stored procedures to log informational, error, and debug messages directly from the procedure itself. The logging framework methods use shared memory concepts to coordinate and cha
Internet/Distributed Computing using HTTP/POST
(Xuan Shi) Much research on semantic Web services has focused on modeling and describing the service aggregation processes as part of the service semantics. This article demonstrates that modeling the process of Web service aggregation should not be a part of the semantic service description fra