Database connectivity gives desktop and Web applications much of their value. .NET developers have products and framework objects that can tie a front-end application to SQL Server, MySQL, Sybase, ...

Application Parts is a template in Microsoft Access that can be added to an existing database to extend its functionality. An Application Part can be a table or include tables, forms, and also ...

Persistence is one of the greatest challenges for building applications. There are many options for building persistence layers. Data Access Objects (DAO) is a popular design pattern for building the ...

A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types. Such information helps audit databases for ...

There's no doubt that Entity Framework with LINQ is great (I've certainly written enough articles about it). But Entity Framework comes at a cost. As Matthew Jones points out on his blog, using ...

The heart of any relational database management system is the system catalog that documents the database objects and system settings being used. The system catalog offers a wealth of information about ...