SQL Script to Return Specific Columns within a Database

http://www.dynamicscare.com/blog/index.php/sql-script-to-return-specific-columns-within-a-database/

Microsoft Dynamics CRM: Workflow Authoring Best Practices

http://blogs.msdn.com/crm/archive/2010/01/15/microsoft-dynamics-crm-workflow-authoring-best-practices.aspx

interesting article on workflow best practices. especially this bit:

4. Correct use of "Execution Time".

The CRM workflow designer provides a property called "Execution Time" which can be used in dynamic expressions such as "if Account(CreatedOn) + 10 days <>

Making Description Field Required in Close Opportunity Dialog

unsupported:

http://a33ik.blogspot.com/2010/01/making-description-field-required-in.html

Setting attribute description as a tooltip for a field in entities forms in Microsoft Dynamics CRM 4.0

http://a33ik.blogspot.com/2010/01/setting-attribute-description-as.html

Many to Many relationships

Some interesting points about both native and manual Many-to-Many relationships
http://www.dynamicscrmtrickbag.com/2010/01/18/many-to-many-relationships/

Sending E-mails with Dynamics CRM Workflows

http://www.dynamicscrmtrickbag.com/2010/01/12/send-emails-with-workflows/

// to clear all picklist options
erm....

// to delete specific picklist options:
crmForm.all.field.DeleteOption(1);
crmForm.all.field.DeleteOption(2);
crmForm.all.field.DeleteOption(3);

// to add new picklist options:
crmForm.all.field.AddOption('Dem (in-house)',1);
crmForm.all.field.AddOption('Presentation (on-site)',2);

NOTE: adding new picklist options that do not otherwise exist will not be saved

Show / Hide field / label / line / section / tab

from http://jianwang.blogspot.com/2007/11/crm-how-to-hide-field-label-line.html

/*hide field only*/
crmForm.all.field.style.display = 'none';

/*hide field and this field's label*/
crmForm.all.field.style.display = 'none';
crmForm.all.field_c.style.display = 'none';

/*hide field and the whole line which contains this field*/
crmForm.all.field.parentElement.parentElement.style.display = 'none';

/*hide field and the section which contains this field*/
crmForm.all.field.parentElement.parentElement.parentElement.style.display = 'none';

/*hide a tab(tab number comes from 0)*/
crmForm.all.tab2Tab.style.display = 'none';