It is often helpful to be able to query SQL Server to find out the schema for a certain database, including tables, information about columns in a particular table, the text of a stored procedure and so forth. This comes in handy when building applications ...

Want to write a rock-solid, dependable application, but in record time? Code efficiency is the key! This article provides useful tools and ideas to speed up your database interactions in ASP, as well as a best-practice you just might be convinced to adapt for your database-driven applications.

Databases are one of the most useful of business programs available. They are perfect for all sorts of data storage and retrieval, for example, employee records, inventory control, client marketing, logistics, equipment records and more.

In my recent XML.com article, Introduction to Native XML Databases, I provided a general overview of native XML databases and what they might be good for. In this article we'll take a look at a native XML database implementation, the open source dbXML Core.

When you need to store and display a modest amount of structured or semistructured data, it's tempting to store it directly in an HTML file. I've used this strategy many times; undoubtedly you have too. The advantages and disadvantages of working directly with a presentation format are pretty clear. It's handy that the "database" is a self-contained package that can be updated using any text editor, emailed, read directly from a file system, or served by any web server.