SP2010 Upgrade Incoming Email does not work

Scenario:
Configured Incoming email on new SP2010 farm as per technet. Database attach upgraded a SP2007 site collection. The host name has not changed in SP2010 but the incoming email server address changed.
Incoming emails are seen in the drop folder but do not get processed. ULS reports "missing alias" errors for the aliases which were working in SP2007.


Solution:
For the library where the incoming email feature is not working, navigate to list settings -> incoming email settings, disable incoming email and enable with same email address


To identify impact on environment using below SQL query against content database,



SELECT Webs.FullUrl, AllLists.tp_Title, AllLists.tp_EmailAlias
FROM AllLists
Inner join webs on AllLists.tp_WebID = Webs.Id
where AllLists.tp_EmailAlias is not null

When to create a Service Application ?

Scenarios where service application development becomes a requirement


Those that share data across site collections or web applications (such as the Web Analytics or Managed Metadata service applications in SPS 2010)

Those that provide specialized calculations or analytics services (such as Web Analytics, Excel Services, or PerformancePoint Services)

Those that aggregate data (such as Search)

Those that are long-running or very intensive processes (such as Web Analytics, Search, or Word services)

Those that are used for middle-tier applications

Reference: http://msdn.microsoft.com/en-us/library/gg193964.aspx

PostBuild - GACUtil

Here is a handy visual studio post build script to GACassemblies and recycle application pools.

gacutil.exe -if "$(TargetDir)$(TargetFileName)"
iisapp /a SharePointContentAppPool /r

Project Server 2010 - Custom workspace template

To create a new workspace template for in project server 2010,
1. Create a new site using Microsoft Project site template
2. Make customizations
3. Save site as template, i.e. solution (wsp file)
4. Download wsp file from solution store and re-upload to pwa site collection. 
5. Activate solution
6. Navigate to Server settings -> Project workspace settings and change default site template.
7. Navigate to Server settings -> Enterprise Project Types (For each project type change the default template)

SP2010 Breadcrumb Missing

Scenario:
On sites with /default.aspx as homepage after migration from SP2007 to SP2010, the breadcrumb is missing on homepage. When you click the folder icon in ribbon it says "The page location is:" and does not show anything else below it.


Solution:
Use SPD to remove, “ContentPlaceHolderId="PlaceHolderTitleBreadcrumb" runat="server"/>” from default.aspx.


Reference: http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/632558af-f9f0-4b54-87e4-cc75a0947b2a 

Target audience - Navigation

Scenario: Target audience does not work for SharePoint groups configured for navigation links on top and left (quick launch) in SharePoint 2010.

Solution: Make sure the User Profile Service application is created and associated to the web application in central administration.

Create sharepoint site in a specific content database

This is possible by using New-SPSite powershell cmdlet in SP2010. Other option which was useful even in SP2007 was to toggle the max site count settings per database.


http://technet.microsoft.com/en-us/library/ff607937.aspx