All about sharepoint people picker

http://blogs.msdn.com/b/rajank/archive/2009/09/01/all-you-want-to-know-about-people-picker-in-sharepoint-functionality-configuration-troubleshooting-part-1.aspx

sp 2010 managed service accounts

auto password change not a good idea.

http://blog.falchionconsulting.com/index.php/2010/10/service-accounts-and-managed-service-accounts-in-sharepoint-2010/

Toubleshooting sharepoint timer jobs for alerts

Find out content db for site having issues

Find out timer job service executing server using,
select * from timerlock

Find other info
select * from eventcache where eventdata is not null
select * from eventlog where ListID='xxx'
select * from eventcache order by EventTime DESC

http://sharepointalert.info/2009/11/troubleshooting-sharepoint-alerts-timer-jobs/

SP2010 ULS to SP List External Content Type BCS

http://gvaro.wordpress.com/2009/12/14/creating-an-external-content-type-to-surface-uls-log-data-into-a-sharepoint-2010-list/

sp2010 health analyzer custom rules

Steps
http://blog.scosby.com/post/2010/04/26/Custom-Health-Rules-in-SharePoint-2010.aspx

Guidelines
http://msdn.microsoft.com/en-us/library/ee535065(office.14).aspx

Pass parameters to CQWP Xsl

Pass parameters to CQWP - XSL
http://blog.mastykarz.nl/extending-content-query-web-part-with-custom-data/

SharePoint 2007 upgrade/deploy solution error

A deployment or retraction is underway

Look for the deploy jobId to break the running by the following command:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm-o enumdeployments
• Cancel the deploy typing the following command:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm-o canceldeployment-id "GUID jobId"
• Check that deploy has been canceled by typing the following command:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm-o enumdeployments