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 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
Take advantage of the Windows Scripting Host to automate processes and get out of the linear mode of programming that ties up a user’s PC. Often when you write programs,
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
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