• Good info on "Ghosting"

    Discussion on how opening/editing a WSS or SPS2003 site in FrontPage2003 un-ghosts the site (places the site’s definition into the SQLdatabase instead of keeping the reference to the one on the server).This can be very bad for performance! SharePointUdiscussion

  • Usage Analysis Tools in SharePoint Products and Technologies

    Good TechNet article on how SharePoint uses access logs (it isactually a chapter from the Microsoft SharePoint Products andTechnologies Resource Kit which you can find here:http://www.microsoft.com/technet/prodtechnol/sppt/reskit/default.mspx): http://www.microsoft.com/technet/prodtechnol/sppt/reskit/c2961881x.mspx

  • Why information is kept about users deleted from site collections

    You can tell if the users have been deleted from the site collectionby looking at the UserInfo table of the content database. If the valueof the tp_Deleted column is 0, then the user is active in the sitecollection. Otherwise, they have been removed. SharePoint keeps this information around because it needs it to linkto the items placed on the sites. If it removed the users completely,the items would become orphaned.

  • Creating New Documents from library menu

    The article is a little hard to understand, but it has some prettygood information about creating additional buttons in libraries so youcan say “New Excel file” or “New Word file” no matter the defaultdocument library’s new file type: http://msd2d.com/newsletter_tip.aspx?section=sharepoint&id=cd3fd32d-b989-4bff-aae7-a65846b795b6

  • In pursuit of the least amount of SQL privileges

    There are some who want to find the least amount of privileges forSharePoint to have in SQL. So, to help out, here is what I have sofar: The account the SharePoint Application Pool is using needs to haveread/write privileges on the content database. It also needs to haveexecute privileges on stored procedures.

  • Host Headers, IIS, SharePoint, & SSL

    Some info on how IIS works with host headers and SSL:You shouldn’t have two sites setup with the same host header (even ifthey are on different servers, UNLESS you are using load-balancing!).A suggestion might be to call it site.dev.domain.com , site.qa.domain.com,site.domain.com as you go through devlopment, testing, and productionenvironments. Also, you have to understand how IIS works. It receives a request for“domain.com” and looks to see if there is a virtual server listeningon port 80 (because no port was defined in the request) that islistening for domain.com (using a host header). If it doesn’t findone, it looks for a site listening on port 80 with no host headerdefined. If it…

  • Change Application Pool on SharePoint IIS site

    To change the application pool for an existing Windows SharePointServices site (IIS virtual server):-Ensure that the new application pool is running under the sameidentity the old AppPool is running as. (if you don’t, then SharePointmay not be able to connect to the content or configuration database)-In IIS, expand Web Sites.-Right-click on the virtual server you want to change and select properties.-On the ‘Home Directory’ tab, under the ‘Application settings’section, change the ‘Application pool:’ to the new application pooland click Apply, then OK.-Back in the Internet Information Services Manager, expand the virtualserver you are changing by clicking the + sign beside the name.-For every Virtual Directory (default virtual directories for a…