You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns.

The Advantage Data Provider for .NET provides a feature-rich mechanism for Delphi developers using the Advantage Database Server (ADS) to build ASP.NET web applications and web services.

From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.

Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.

If you're a .NET newbie coming from Access or SQL Server, let .NET do the hard work of creating a connection to foreign data. Then customize the resulting control to add functionality.

You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.

Oracle 10g introduced a new feature called ROWDEPENDENCIES, which made every row independent. Learn how to use this feature to improve application concurrency and avoid the dreaded ORA-8177 error.

Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.

This short introduction to .NET shows Access and SQL Server developers how to use a development tool to create connections to data and a user interface to manipulate that data.

Windows Communication Foundation is one of the most important features in the history of .NET. Not only does WCF provide a unified programming model for communications, it also promotes the use of interfaces and various recommended programming practices.

A column alias seems like a great tool for referencing complex expressions, but SQL Server doesn't work that way. Learn a simple workaround.

Although adding multiprocessing capabilities to applications is labor-intensive and error-prone, adding multicore capability to SQL query processing can be automatic, benefiting huge numbers of applications with little developer effort.

Deleting all the data in a SQL Server database doesn't have to involve complex code. The undocumented stored procedure sp_MSForEachTable safely bypasses built-in limitations to accomplish this common task.

Every application uses data, and Android applications are no exception. Android uses the open-source, stand-alone SQL database, SQLite. Learn how to create and manipulate a SQLite database for your Android app.

SQL Server's new FILESTREAM feature simplifies the process of keeping file-based data, such as images, in sync with relational data.

Determining which queries will provide the best performance for a given application often comes down to a simple question: Does Query X perform better than Query Y? Learn the tools and methods that can help you compare query response times in Oracle.

You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.

You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.

Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. Find it here.

Once you've established a connection between an Adobe AIR application and a local database, you can run SQL commands (CREATE TABLE, INSERT, DELETE, SELECT, etc.) using the flash.data.SQLStatement class. Find out how.