My Sharepoint Learnings

The user profile properties values are stored in SSP tables in MOSS 2007. The values can be found in UserProfileValue table in SSP The values are stored for each of the Record ID. Each RecordID corresponds to one user. Also in the table, the values are given for each PropertyID The mapping of PropertyID and its corresponding description can be found in the table PropertyList. Note - it is not advisable to manipulate the SSP DB's.

The error came when trying to install a hotfix/patch to the sharepoint server. The issue had occurred because there was an old copy of the database which was used for detach and attach. Had tried to create a new webapplication using a copy of the running webapplication in the same farm. It encountered error since there was a DB id conflict in the configuration DB. So deleted the web application, but the content DB had not been deleted completely. So ran the stsadm delete old database command to remove it Stsadm -o sync -deleteolddatabases 0 More about deleteolddatabase -  http://technet.microsoft.com/en-us/library/cc263196.aspx

Came across an interesting blog on using the Touch Touch jquery plugin which helps to create a touch enabled picture library from Sharepoint 2010. To know more, read - http://summit7systems.com/blogs/touch-optimized-jquery-picture-gallery-in-sharepoint-2010-and-office-365/

The powershell commands to delete the unwanted app pools in Sharepoint  Go to Programs --> Sharepoint 2010 Products --> Sharepoint 2010 management Shell Type the command -- Get-SPServiceApplicationPool | select Name It would display the set of names. Enter the below command to remove/delete the app pool Remove-SPServiceApplicationPool -Identity "<enter the unwanted app pool name>" It would ask for confirmation, enter 'Y' to complete the removal.