August 12, 2009

Accommodating Null Values in SQL Server

espite having a good understanding of the term null, most developers still fail to adequately accommodate null values in their databases. Accommodating null values appropriately is an important part of

Adding an Installer Class to a Windows Service

Visual Studio makes it simple to add an installer class to your Windows service. Here are the steps: Open the “Solution Explorer” (press Ctrl-Alt-L, or go to the “View” menu

Determining Merge Errors in a Typed DataSet

Merging typed DataSets can cause a “Merge Constraint” error, which explains the problem, but doesn’t help much in solving it. Here’s how to find the exact cause of the error: