Learn how to use SQL Modeling Services to hunt for interdependencies without having to access source code.

In today's column we'll demonstrate how and when to use the new TSQL MERGE statement and how this can be a helpful addition to your toolbox.

This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries. We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.

Sometimes when you have all kinds of data what you really need is XML. LINQ to XML let's you employ functional construction to convert your data into XML.

Providing a drop down list in your ASP.NET Web applications help users avoid wasting time with bad data and it's a kinder, gentler thing to do.

Elevate your SQL game (a little bit) with CROSS APPLY and OUTER APPLY.

Devexpress has a commitment to providing amazing ASP.NET (and other controls), such as their latest revision of their ASPxGridView, version 8.3, which supports filtering, grouping, sorting, and much more, with little or no coding on your part.

LINQ to SQL eliminates SQL Injection Attacks and is easier to use than straight SQL to boot.

ADO.NET 3.0 and the ADO.NET Entity Framework are designed to let you spend less time writing SQL and database plumbing code and more time working in the space of the problem you are trying to solve.

Learn how to make Visual Studio Team Suite Database Edition part of your development process.

Learn how to implement a Left Outer Join with LINQ.

Manipulating data with ADO.NET can be easy. Discover the steps to creating a simple form to add, update, and delete database records using ADO.NET.

Discover a quick (and easy) introduction to using ADO.NET to read information from a database.

You can use LINQ to SQL to define an Object Relational Mapping between SQL tables and then query those tables with LINQ.

This is a fully functional sample that shows some advanced features that would be hard to do with bound controls.

Learn about local type inference in C# 3.0 and Visual Basic 9.0. Examine why it is relevant and the syntax for its use.

See how a setup project with a custom action lets the user define the connection string using the Data Links dialog and encrypt that connection string using RSA encryption.

There's no need to store file system paths in a database. Just store images in your database and then directly load them to your ASP.NET pages.

XML Data Binding allows you to manipulate an XML document via a set of simple objects. Learn about the generation of these objects, and see a summary of the existing products on the market.

Tired of checking database entries for null values? This month, Paul illustrates how you can use Nullable types to make fields and properties accept nulls.

Learn about a web service method to back up a database from a mobile device using the SQL Backup command and asynchronous method calls.

Dare to enter the world of approximate string matching with this introduction, tutorial, and Access 2000 database demo with a 99% precision/recall.

The write part of managing a data access layer is where things can go awry. Writing requires managing changes, validation, and transactions. Learn how to handle the challenge.

Did you replace MSDE with SQL Server 2005 Express Edition? Did you make the wrong move?

Learn about an Oracle query tool with Syntax Highlight and a tabbed MDI interface.