Skip to main content

Posts

Showing posts from October, 2010

SharePoint Filtered Views in List and Libraries

For lists and libraries with large numbers of items, users can access the items with a mix of views and search. The following are some suggestions for views that work well with an indexed column: Recently changed: To create a view of only the items that have changed in the past week, you can index the Modified column and then apply the filter Modified (Indexed) is greater than [Today]-7. New items: To create a view of only those items that were added in the past week, you can index the Created column and then apply the filter Created is greater than [Today]-7. My items: To create a view of only those items that you added, you can index the Created By column and then apply the filter Created By is equal to [Me]. Due today: For lists or libraries with a Due Date column, you can index that column and then apply the filter Due Date is equal to [Today]. Discussion board updates: To create a view of only the discussions that were updated in the past month, you can index the Last Up...

SQL Server Version

SQL Server 2008 R2 10.5.1720.0 SQL Server 2008 R2 CU2 25 June 2010 10.5.1702.0 SQL Server 2008 R2 CU1 18 May 2010 10.5.1600.1 SQL Server 2008 R2 RTM 12 Apr 201 Bill Graziano at SQLTeam.com has a listing of all the SQL Server versions that come in very handy: http://www.sqlteam.com/article/sql-server-versions

MCTS SharePoint 2010 Application Development 70-573 Study Guide

There are several study guides about now for example: http://blog.beckybertram.com/Lists/Exam%2070573%20Study%20Guide/AllItems.aspx and http://techtrainingnotes.blogspot.com/2010/05/sharepoint-2010-part-1-preparing-for-70.html, but I wanted to record the articles and blogs etc I’d used. To help I’ve copied in the Microsoft learning content from http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-573&locale=en-us#tab2 Working with the SharePoint User Interface (19%) Manage SPSite and SPWeb programmatically by using Visual Studio 2010 Read Inside Windows SharePoint Services 3.0 book: http://www.amazon.co.uk/Inside-Windows-SharePoint-Services-Developer/dp/0735623201/ref=sr_1_1?ie=UTF8&s=books&qid=1282250087&sr=8-1 Implement a dialog by using the Dialog Framework Tobias Zimmergren’s article on the status bar: http://www.zimmergren.net/archive/2010/03/17/sp-2010-dynamically-displaying-messages-to-your-users-with-the-notification-and-status-bar-areas-in-sharepo...

SharePoint Email alert is not working

Question: How to Troubleshoot Alerts in WSS 3.0 / MOSS Answer: The most common issue in alert is the user will get the initial email, but will not get when changes are made to the list where he configured the alert. Check the following settings in order and ensure that it is correct. 1. Is it an upgrade from V2 to V3? If yes, check the upgrade section at the bottom of this page. 2. If this is a new install of V3 (WSS or MOSS), then do the following a. Create a new web app and see if the alerts work there. If yes, you can move the content db of the non-working site to this one. If customer is not ready to do that, then try the following. b. Open the command prompt and go to the 12\Bin folder. Run this command and see whether alerts are enabled for the web application. Stsadm.exe-o getproperty -url http://problemsite -pn alerts-enabled The expected output is . If you don’t get this, run the following command to change the value. stsadm.exe -o s...

LINQPAD

For .NET Framework 4.0: & For .NET Framework 3.5: Download LINQPad.exe http://www.linqpad.net/ How to use Effectively in LINQPAD below video will explain you more…

SharePoint 2010 Announcement webpart Background color

To change the Background color of the Announcement webpart. Please find the following script tag. Open the announcement webpart home page in sharepoint designer Add the following script.

Publishing site is not listing all list & Libraries

When you are working on the publishing site by default all list and libraries it will not appear. if you want list like announcement & quick links then you need to active the "Team Collobration Lists" Feature