What elements comprise a database? This article deals mainly with the objects that comprise a database. Several concepts are worthy of coverage within the scope of the database as it relates to database design. As you work with data and databases, you will see how the origination of business information and databases is formulated into database elements. The intent here is to provide a brief coverage of basic database elements to provide you with a basic understanding of the elements found in a database.

Showcases the XML functionality of SQL Server 2000 by turning SQL Server into an object repository using XML as the bridge between relational and object-oriented data.

Find out how well IBM DB2, Microsoft SQL Server 2000, Oracle Database 10g, and Sybase ASE handle the structured documents that drive today's business.

More and more often, enterprise developers of all stripes (Java, VB/.NET, C++, etc.) are asked to build cross-database access for applications and end users. A growing list of methods to exploit features and libraries in JDBC, OBDC, ADOdb, JDO, SQL and XML are available to developers for such one-off integration projects.

In this tutorial, you'll learn about authentication and how to use hashes alone and with salt for better password protection.

Doug explains how to get data out of the SqlDataReader. He explains how to get the column data including GetString(), GetDateTime(), GetValue(), etc.

Xml has become a very ubiquitous and is an integral part of .Net and the System.Data namespace. The problem lies in that not many people know how to take advantage of some of the features. When we are using a database, we naturally use the Systen.Data namespace, but with Xml documents as data there are hundreds of solutions for displaying Xml data out there for .Net.

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.

In this article, you’ll learn how to extract a list of stored procedures from a database, plus information about the parameters associated with the stored procedure. Finally, you’ll see how to take this information and use it to call a stored procedure on the fly.

This tutorial explains how to use to allow insertion of multiple rows into a database table based on the data entered into a form by a user.

Along with database design, Indexes are the backbone of optimal database performance. It requires specialist knowledge to ensure that you have the right indexes for the right job and this article will provide you with enough knowledge to make the right choices - and to know when to use an index and when not.

In this tutorial we are going to talk about yet another powerful feature of database programming, Stored Procedures.

In this tutorial, for beginners to database design, Rob Stuttaford writes on how to design databases that are normalised - the process of breaking data down into its most basic components.

Learn Access programming tips such as displaying a range of dates in a Calendar control, creating a blinking label prompt for a text box, converting a number from one base to another, and more.

Connecting to a MySQL Database from within UltraDev can be a little daunting, especially if you're new to UltraDev. This tutorial explains how to connect to a MySQL database using MyODBC. Extremely usefull for PHAkt users!

Welcome to an introduction on database performance tuning and optimisation. My previous tutorial, SQL Made Simple, looked at a normalised database, and explored some of the queries we would use to make information from data in its normalised state. Today, we’re going to look at ways to shorten query processing time on this same database.

In this tutorial we will learn what are the two common ways of displaying data from an SQL Server database using ADO.NET in an ASP.NET page.

The tutorial series will look at the different methods of retrieving data, always aware that this is the Web and that speed is of the essence, how to monitor performance of your database and tune it for maximum speed.

This tutorial shows how to use a nested query on a parent/child table to count the records in that child table and display them togehter with the parent record.

As part of Integration Developer News reference libraries series for "developers as integrators," we present the latest techniques and resources from leading developers concerned with cross-database integration.