How to Shrink SQL Log DB

In SharePoint if we are not taking backup periodically the log db of content database will grow very large, We can shrink the log db using the following command in SQL Server.

Use db_name

DBCC SHRINKFILE(dblogfilename,1)

BACKUP LOG db_name WITH TRUNCATE_ONLY

DBCC SHRINKFILE(dblogfilename,1)

Also check this link for script to shrink the log db.

Moss How to remove My settings in Welcome Menu

Sometime you may want to hide the MySettings menu item from the Welcome control of SharePoint
You can follow the steps below:

1. Take a copy of Welcome.ascx file (under 12 hive\Template\ControlTemplates folder)
2. Rename it as CustWelcome.ascx
3. Find the tag with Personalization For Eg:

<SharePoint:MenuItemTemplate runat=”server” id=”ID_PersonalInformation”
Text=”<%$Resources:wss,personalactions_personalinformation%>”
Description=”<%$Resources:wss,personalactions_personalinformationdescription%>”
MenuGroupId=”100″
Sequence=”100″
ImageUrl=”/_layouts/images/menuprofile.gif”
UseShortId=”true”
Visible=”true”
/>
Change the Visible to false (if visible is missing add it and set it as false)

<SharePoint:MenuItemTemplate runat=”server” id=”ID_PersonalInformation”
Text=”<%$Resources:wss,personalactions_personalinformation%>”
Description=”<%$Resources:wss,personalactions_personalinformationdescription%>”
MenuGroupId=”100″
Sequence=”100″
ImageUrl=”/_layouts/images/menuprofile.gif”
UseShortId=”true”
Visible=”false”
/>

Now go to the master page and change the reference from welcome.ascx file to CustWelcome.ascx

WSS Explorer

One of the nice tool to explore SharePoint Web App/Site Collection/Sites/Items,etc is to use WSS Explorer. You can download it from MSDN