June 2006 - Posts

Wed, Jun 7 2006 11:26 PM

Code quality

For the last 6 weeks i'm working  for a new customer. The project we are working on consist of 20 to 25 developers. Some of the code I have seen are too awful. For example:  functions with 600 lines, use of hungarion name concention, no comments, bad name conventions.

No hungarion notation please! Read :

Code review and refactoring code is really needed here.  I'm afraid the project leader dont' see the problem yet. But in the long term the business will have to deal with spending more money to get equal functionality. I will have to convience him that this is high priority to improve the quality of the application..

References:

Posted by Chi Wai Man | 5 comment(s)
Filed under: ,
Thu, Jun 1 2006 11:52 PM

Intellisense in SQL Server Analyzer with SQL Prompt

Always wanted intellisense in Query Analyzer? Go to the website of red-gate and try it out. The download is free till 1st of september.

SQL Prompt is also known as PromptSQL sold by Atadore SARL.

A short summary:

  • Just press CTRL + SPACE to trigger intellisense. Althought it don't work perfectly sometimes;
  • Recognizes related tables in a join. Note that JOIN functionality only works if you have table relationships explicitly defined in your database;
  • Automatically uppercase keywords such as: select , from and etc;
  • Inserts your own predefined code snippets
Related links:

Posted by Chi Wai Man | with no comments
Filed under: ,
Thu, Jun 1 2006 10:29 PM

Testing in Team system

A msdn page with several articles about testing in Team system
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/utfwvs05tmsys.asp
Posted by Chi Wai Man | with no comments
Filed under: