Found this pretty good blog entry about displaying usernames onSharePoint pages:MSDNBlog on Username display
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
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
Short article about custom templates: Microsoft support article Thanks lffiby!Ref. post
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.
A great article on conditional formatting:WSSDemo article Thanks Mark!Ref. post
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
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.
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…
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…