Calculate the size of log file in Database

To calculate the size of Log file use the follwoing script:

SELECT DB_NAME(database_id) AS DatabaseName,
Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'AdventureWorks'
GO

The reference: http://blog.sqlauthority.com/2010/02/08/sql-server-find-the-size-of-database-file-find-the-size-of-log-file/

Copy sharepoint pages or folders containing webparts

There is way to copy sharepoint pages that contains webparts to another location without lose the webpart, only follow the following steps:

1- Open sharepoint designer.

2- Go to target page or folder.

3- Right-Click, and chose "Publish Selected Files...".

4- Save it to anywhere on your computer.

5- Copy the published files.

6- Paste it anywhere you want by sharepoint designer.

Sharepoint search as you type with jquery

Very very good idea :)

http://weblogs.asp.net/jan/archive/2009/07/02/sharepoint-search-as-you-type-with-jquery.aspx

 

Step-By-Step build Advanced InfoPath Form and SharePoint Designer Workflow

https://docs.google.com/open?id=0B8n32NOpZd1aXzdNY2VjTmllZUE

This item cannot be deleted because it is still referenced by other pages

If you create a new master page, and you want delete it, sometimes the error will happen:

This item cannot be deleted because it is still referenced by other pages

what you can do???

aha, there is work around to delete it, easy way:

        1- Open the sharepoint designer.

        2- Create a new folder.

        3- Put the target master page into new folder.

        4- Delete the folder.

Enable the Ajax on MOSS 2007

http://www.telerik.com/help/aspnet-ajax/moss-install-aspnet-ajax-35.html

Select a specific column in table by content

To select a specific column by content, you can use the following jquery code:

$(document).ready(function () {
        $('td').each(function () {
            var $tds = $(this).find('td');
            if ($tds.text() == "System Settings") {
                <!--alert($currText = $tds.eq(0).text());-->
                $tds.css("background-color", "#F6F6F6");
            }

Permission level cannot be found

Permission level cannot be found. at Microsoft.SharePoint.SPRoleDefinitionCollection.get_Item(String name)

This message happend when you try set permission to user in sharepoint by code with rong spelling.

Such us: you want set "Contribute" for the user, but you write it: "Contributer".

Enterprise Search Case Study

http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=4000011274

Inspiring sharepoint based university sites

http://microsoftfeed.com/2011/50-inspiring-sharepoint-based-university-sites/