July 3, 1998

Always Use Relative Paths

No matter what language you are developing in, or whether you are developing programs or Web pages, never hard code paths to files that include drive letter distinctions (i.e. N:Images).

SQL Feature to Integrate with COM Objects

SQL Server has a very powerful, but often overlooked, feature to integrate with COM objects. SQL itself can create COM objects from within Triggers or Stored Procedures, apply property values

Utilize Version Control Mechanisms

If you are using SQL server, consider utilizing version control mechanisms for your triggers and stored procedures. Many times I have heard people wondering about changes to a procedure or

Scheduled Walkthroughs and Reviews

Successful development groups implement regularly scheduled walkthroughs and reviews. I have found three common types: Code Walkthrough – At various points during the development life cycle, the developer or project