(Dina Fleet Berry) A handler is responsible for fulfilling requests from a browser. Requests that a browser manages are either handled by file extension (or lack thereof) or by calling the handler directly. Only one handler can be called per request. A handler does not have any HTML static text like
Other News
Query DB2 XML data with XQuery
(Don Chamberlin and Cynthia M. Saracco) By now, you’ve probably heard about DB2 Viper’s new architecture, which supports both tabular and hierarchical data structures. Indeed, previous articles have summarized DB2’s new XML features, described how to create database objects and populate them with XM
Quick Debugger Visualizers in Visual Studio 2005
(Mike Gunderloy) Debugging in Visual Studio is a wonderful thing. You can use the tools built into the debugger to drill into the values of objects and their member variables easily. But even wonderful things can be improved, and that’s exactly what Microsoft has done with the introduction of debugg
Do you know you can monitor your units of recovery (UR)?
(Willie Favero) I hope today’s topic for discussion is old news to most of you. It would be great knowing that someone paid attention in one of my IDUG or DB2 Tech Conference presentation on DSNZPARMs. However, some of you all may have just not had the opportunity to hear it yet. This entry is for y
Best Practices in Metadata Management
(Anne Marie Smith) Literally “data about data”, metadata is a concept that is receiving increased visibility throughout the information systems communities, making the need for understanding metadata and its varied roles across the design and use of systems and the information they capture. To make
XML and Web services: SOAP
(William Brogden) Early experiments with XML-based messaging using XML-RPC encouraged the development of an extension called SOAP. In the initial submission to the W3C, SOAP was said to stand for Simple Object Access Protocol. Many people have pointed out that SOAP is not particularly simple and doe
Why should I create an index?
(Conor) There are many cases where the database administrator does not control the queries being submitted of the system. As a result, the physical database design is often not tuned as well as it could be. In a number of actual customer cases where we investigated performance issues with them, we
Oracle 10g Warehousing, VLDB & Analytical Features
(Garry Robinson) A change in the default behaviour of the skip_unusable_indexes parameter. The new default is TRUE which means Oracle will not error, but instead just write a warning to the alert log when it comes across an unusable index that it has skipped. If an index is used to enforce a UNIQUE
Nullifying foreign key statements when loading a test dev MySQL database
(Mike Hillyer) Is there a way to write a SQL statement that will override (set to null) all foreign keys? I want to use this when loading a test development MySQL database. (R)
ASP.NET tutorial: binding a datareader to a datalist using SQL server and C#
The first step in binding a datareader to a datalist is to import the System.Data.SqlClient namespace and have ASP.NET connect to SQL Server. This gives you access to the classes necessary to retrieve data from a SQL Server database. More on .net datareader performance in this asp.net tutorial