(Xiangyang Liu) An extremely flexible and easy-to-use library that retrieves data in XML format, supports simple parameterized queries, stored procedures, and transactions. It can also be used as a web service.

(Michael M. David) SQL/XML integration is in a mess today. Every SQL vendor’s XML support is proprietary and still does not integrate seamlessly, fully, or satisfactorily. The current working standards solutions, XQuery (when used in SQL) and the SQL/XML Standard are very XML centric and do not inte

This article describes how to create an Indexer property in Visual Basic .NET by using the default property attribute.

(Thiru Thangarathinam) One of the excellent features of the next release of SQL Server, known as SQL Server 2005, is its deep XML integration with the SQL Server database engine. This integration goes well beyond the simple relational-to-XML mapping layer that SQL Server 2000 provided. SQL Server 20

(James Ervin) One of PHP’s strongest features as a scripting language for Web applications is its diverse database support: the “What Can PHP Do?” page lists over 20 database platforms that PHP can communicate with. The PHP-MySQL combination powers numerous high-profile Web sites worldwide. However,

(April Wells) Why is normalization important? Many databases today are still denormalized for many reasons. This article, by April Wells, addresses some of the reasons and normalizes a claim table through the different normal forms for an insurance company. The changes in the table and the addit

(Mitchell2.24v) This article describes a small utility that can be used to reset a database to a clean state. During development of applications that use databases this may be needed quite frequently. This utility was built quickly and will therefore not win any style points, but it works for m

(Joel Murach) This tutorial shows how to use a Java servlet, a JavaServer Page (JSP), and a static Java class to create an application that can be used to interactively execute any standard SQL statement against a database that’s running on a server. You can use an application like this one to w

(Ramesh Balaji and Scott Mitchell) ADO, as you likely know, is used to access databases (or more generic data stores). The work that we normally perform with ADO when working with database can be categorized into the following two activities: 1. Data Definition 2. Data Manipulation

(Fritz Onion) f you’re a seasoned ASP.NET developer, the mere mention of view state probably sends shivers down your spine, as you envision kilobytes of base64-encoded data being sucked through a cocktail straw. Unless you take steps to prevent it, most ASP.NET pages will have a significant amount o