(Tony Marston) This tutorial is intended for developers who wish to extract data from a database and insert it into XML files so that it can be processed in some way, usually by transforming it into HTML using an XSL file.
Other News
Manage XML collections with XAPI
(Uche Ogbuji) XML repositories are a simple extension of the idea of XML documents, and they call for a simple API for access and manipulation. The likes of DOM and XPath are too granular, while XQuery may be too elaborate for some needs. A group of XML repository implementers (named XML:DB) have co
Building Database-driven Applications with JSF
(Andrei Cioroianu) JavaServer Faces (JSF) is the long-awaited standard Java technology for creating Web-based user interfaces. In this article, I will explain how to build JSF forms, validate the form data with JSF, implement JSF actions that access the database, and present the SQL result sets with
Why You Need a Code Profiler
(Robin Schumacher) What do you do when a stored procedure that is thousands of lines long takes much longer to run than desired? And what do you do when a nightly batch job, consisting of five stored procedures, each thousands of lines long, used to run in fifteen minutes, but now is crossing the fi
Perform HTML form validation with ASP.NET
(Phillip Perkins) Most business applications involve data input, validation, and some form of output. Web applications are no different.
Managing index fragmentation in SQL Server
(Barrie Sosinsky) Database indices are a key determinant in your database performance. Every time you run a query, create a view or cursor or retrieve a dataset in some way, you are hitting up against indices. Put aside the instances where you are building indices on the fly; all of the longest-runn
Open source reshaping services market
(Martin LaMonica) The open-source movement has already rewritten the rules for how software is licensed and used. Now the computer services market is changing to keep up.
Global System Hooks in .NET
(Michael Kennedy) This article discusses the use of global system hooks in .NET applications. A reusable class library is developed along the way.
The Cost of GUIDs as Primary Keys
(Jimmy Nilsson) In this article, the author presents the pros and cons of using globally unique identifiers (GUIDs) as the datatype for primary keys in SQL Server 2000. In doing so, he shows you test results that hint of performance characteristics and introduces you to a special type of GUID that h
DB2 Alphablox: Develop DB2 Alphablox applications with WebSphere Studio Application Developer
(Peter Bendel) IBM DB2 Alphablox is the new IBM offering that enables users to develop custom Web-based analytic applications for relational databases, such as DB2, relational cubes in DB2 (star schema), or multidimensional databases, such as IBM DB2 OLAP Server. In this article learn how you can us