SPQuery & CAML

 http://shaiju-sp.blogspot.com/

http://aravindrises.blogspot.com/

http://blogs.msdn.com/pranab/archive/2008/02/14/how-to-set-item-level-permission-for-sharepoint-2007-moss-wss-list-document-library-programmatically-part-2.aspx

http://www.developerfusion.com/community/blog-entry/8389447/how-we-did-it-automating-service-requests-using-infopath-forms-services/

http://www.windows-tech.info/6/5a56eccf1e58a850.php

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/076c57b1-a780-4b86-b00b-849fa8789318/

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/597f48ed-6824-4bca-bca4-870e45bc59b4/

http://www.codeplex.com/SPCamlViewer

http://www.dailycode.net/blog/post/SPQuery-One-or-more-field-types-are-not-installed-properly.-Go-to-the-list-settings-page-to-delete-these-fields.aspx

http://www.stum.de/2008/02/06/querying-the-person-or-group-field-using-spquery/

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/4c37919f-f4e3-4e42-95d4-a810bdc6a71a/

http://www.beyondweblogs.com/post/SharePoint-Using-Queries-for-List-Data-with-CAML-in-WSS-30.aspx

http://www.zimmergren.net/archive/2008/05/05/how-to-easily-construct-your-caml-queries-with-spquery.aspx

http://aidangarnish.net/blog/post/2007/11/Using-SPQuery-and-CAML-to-filter-and-order.aspx

http://it.toolbox.com/blogs/sharepoint-blog/using-and-in-spquery-16956

http://www.sharepointblogs.com/ssa/archive/2007/06/15/using-quot-and-quot-in-spquery.aspx

Forms Authentication in SharePoint modules

http://msdn.microsoft.com/en-us/library/bb975136.aspx

Getting Started with SharePoint Web Services

http://www.infoq.com/articles/swanson-moss-web-services

RPC Server is unavailable error

http://support.microsoft.com/kb/884564

http://community.spiceworks.com/topic/3917

Moving your MySite location in MOSS

http://blogs.msdn.com/cjohnson/archive/2006/09/15/754902.aspx

Download sites

http://www.9down.com/

http://www.tucows.com/

Merge cells in Excel 2003

http://office.microsoft.com/en-us/excel/HP052510211033.aspx#MergeCells

Get List of Users in a SharePoint Group

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/939ab3c2-c8c9-4a76-9501-dfa732e98260/

Use External Database with SharePoint

http://grounding.co.za/blogs/neil/archive/2007/12/17/connecting-an-external-database-to-sharepoint-using-the-bdc.aspx

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/e3d7a890-8421-47c8-90e8-937c057f054c/

http://joeshepherd.spaces.live.com/Blog/cns!9AE2097A4A610B63!127.entry

http://www.codeplex.com/threetierwss/Release/ProjectReleases.aspx?ReleaseId=2856

Unable to Copy file during Build

http://social.msdn.microsoft.com/Forums/en-US/csharpide/thread/68648642-08d8-4cff-b0c3-c2782f010589/

Create a blog using SharePoint

http://www.bluedoglimited.com/SharePointThoughts/ViewPost.aspx?ID=90

SharePoint KPIs

http://sharepointservices.wordpress.com/tag/sharepoint-list/

Microsoft Charts Controls & Integration with MOSS

http://mosshowto.blogspot.com/2008/11/chart-controls-net-framework-sharepoint.html
http://social.technet.microsoft.com/Forums/en-US/MSWinWebChart/thread/ac4eb618-4da3-4961-a39b-6eaf7e679884/
http://msmvps.com/blogs/brianmadsen/archive/2008/11/26/microsoft-releases-chart-controls-for-net-3-5-sp1-and-they-re-free.aspx

 

Missing Edit in Datasheet option

http://sharingpoint.blogspot.com/2005/01/extreme-sharepoint-design-missing-edit.html

SharePoint Workflows & Email

http://www.endusersharepoint.com/?p=709

Widgets

http://www.widgetbox.com/

SharePoint Alert Timer Job

http://www.niral.net/blog/sharepoint-delay-activity-timer

Getting HTTP 404 error on SharePoint site

All of a sudden my power went out while I was working on my SharePoint site and my server went down. After power supply was restarted I could not open my sharepoint site and it was giving errors like:

Unknown error
an unknown error has occurred
and finally the HTTP 404 page not found error

When I checked the event viewer I could see the error as:

Event Type:    Error

Event Source:    Windows SharePoint Services 3

Event Category:    Database

Event ID:    3760

Date:        12/18/2008

Time:        3:52:30 PM

User:        N/A

Computer:    ***-******

Description:

SQL Database 'WSS_Content_8ddc90d116d0456a92bbf1934103b6f1' on SQL Server instance '***-******\OfficeServers' not found. Additional error information from SQL Server is included below.

 

Cannot open database "WSS_Content_8ddc90d116d0456a99bbf1914103b8f1" requested by the login. The login failed.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

 

When I opened my SQL Server; I saw the above mentioned database had a (suspect) keyword associated with it. I performed a search for resolving suspect databases and finally I got this set of queries that resolved my problem:

EXEC sp_resetstatus 'yourDBname';
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb('yourDBname')
ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE yourDBname SET MULTI_USER

http://blog.cybner.com.au/2007/10/your-sql-2005-database-is-suspect.html

http://www.codeproject.com/KB/reporting-services/SQL_2005_Suspect_Database.aspx

“Collect Feedback” workflow not starting

I was activating a SharePoint built-in workflow on a document library but I got this error:

 

The workflow failed to start due to an internal error.

Troubleshoot issues with Windows SharePoint Services.

This error creates an event in the event viewer which goes like this:

 

The Execute method of job definition ScheduleAlertJob.ScheduleAlertJobDefinition (ID 73212e15-2ea1-4e19-8724-213e37e39f81) threw an exception. More information is included below.

 

Error saving file, access is denied or invalid path.

I resolved this issue by going to the top level website and in site collection features, activated "Routing workflows" feature.

More about SharePoint Workflows & Scheduling

http://office.microsoft.com/en-us/sharepointdesigner/HA101005871033.aspx

http://parkesy.wordpress.com/2008/07/18/sharepoint-incoming-emails-automatic-workflows-sorted-3/

http://blogs.interknowlogy.com/rodneyguzman/archive/2007/03/20/12405.aspx

http://www.articlealley.com/article_661904_10.html

http://stackoverflow.com/questions/349387/workflow-auto-cleanup-timer-job-does-not-run

https://www.surfgroepen.nl/_layouts/help.aspx?lcid=1033&cid0=MS.OSS.manifest&tid=MS.OSS.HA10154424

http://www.finalcandidate.com/en/tandp/Pages/SharePointWorkflow.aspx

http://groups.google.com/group/microsoft.public.sharepoint.portalserver.development/browse_thread/thread/73e1802ac9b4ae18

http://www.devx.com/webdev/Article/34032/1954

How to troubleshoot mysterious SharePoint errors

http://paulgalvin.spaces.live.com/Blog/cns!1CC1EDB3DAA9B8AA!154.entry

VBScript examples

http://www.veign.com/development-category.php?type=web&catid=45

SharePoint Color Calendar

http://planetwilson.blogspot.com/2008/02/version-2-of-colour-calendar-released.html

File Handling Tutorials using ASP/VBScript

http://pacosdrivers.com/asp/page.asp?start=11&ID=9

SPD Workflow Lookups

http://itfootprint.wordpress.com/2008/04/09/sharepoint-designer-default-workflow-actions/

http://office.microsoft.com/en-us/sharepointdesigner/HA102378301033.aspx

http://stackoverflow.com/questions/131238/in-sharepoint-designers-workflow-editor-how-do-i-get-the-workflow-initiators-us

http://davesquared.blogspot.com/2007/07/sending-email-to-group-with-sharepoint.html

http://www.shannonbray.com/2008_04_01_archive.html

Getting SharePoint reminders in Outlook

http://liebrand.wordpress.com/2007/12/11/getting-sharepoint-calendar-reminders-in-outlook/

SPD Reminder Workflow

http://bluesurftech.com/TechBlog/Lists/Posts/Post.aspx?List=f66fed30%2Da22a%2D43f6%2Da52b%2D5a2f3bedd6e7&ID=18

Form Validation in SharePoint

http://www.codeproject.com/KB/sharepoint/Control_validation.aspx

SharePoint Calculated Columns

http://www.endusersharepoint.com/?cat=397

http://office.microsoft.com/en-us/sharepointtechnology/CH100650061033.aspx

http://office.microsoft.com/en-us/sharepointtechnology/HA101054791033.aspx?pid=CH100650061033

http://blogs.technet.com/collaboration/archive/2008/03/28/functions-for-use-in-a-moss-2007-column-today-me-other.aspx

SharePoint Designer

http://blogs.msdn.com/publicsector/archive/2007/05/22/document-workflow-how-to-sending-an-email-with-sharepoint-2007-moss.aspx

http://sharepointsolutions.blogspot.com/2007/10/sharepoint-designer-workflows-how-to.html

http://blog.dreamdevil.com/index.php/tag/sharepoint-2007/

http://patrikluca.blogspot.com/2008/11/lookup-user-info-in-workflow.html

http://unitedsupplyco.sharepointsite.net/publicfacing/bensblog/default.aspx

http://unitedsupplyco.sharepointsite.net/publicfacing/bensblog/Lists/Posts/Post.aspx?ID=54

Sending Email using SharePoint Designer Workflows - Ways

http://office.microsoft.com/en-us/sharepointdesigner/HA102390421033.aspx

Troubleshooting SharePoint SMTP

I was getting this error when I sent an email using an SPD workflow:

"The e-mail message cannot be sent. Make sure the outgoing e-mail settings for the server are configured correctly"

When I checked the event viewer I found this error:

"An error occurred while talking to SMTP host"

I tested the SMTP by creating a simple aspx page which sent an email. This page was working correctly.

Following steps resolved the issue:

• Use the IP address instead of the pc name in SharePoint SMTP settings
  
• IIS Manager > SMTP Server > Properties > Access > Connections > Allow all except the following (make sure the list below is empty)
  
• Also make sure that your SMTP defined in Central Admin > Operations and your SMTP defined in Central Admin > Application Management > Outbound SMTP Settings do not conflict with each other.

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/7a6a8718-d1c7-490b-95d1-f3b74c5b0f3d/

Display Charts in SharePoint using Excel Services

http://www.codeproject.com/KB/sharepoint/DisplayingCharts.aspx

Download WSS 3.0 Application Templates

http://www.microsoft.com/downloads/details.aspx?familyid=5807B5EF-57A1-47CB-8666-78C1363F127D&displaylang=en

Graph/Chart creation in SharePoint

http://blog.webtechy.co.uk/blog/_archives/2006/8/2/2190345.html

http://cid-62b84429c3a8a991.skydrive.live.com/browse.aspx/SharePoint

Install Office Web parts on MOSS 2007

http://msmvps.com/blogs/shane/archive/2006/09/02/How-to-manually-install-the-Office-Web-Parts-in-SharePoint-v3.aspx

Logging into SharePoint Designer

http://social.msdn.microsoft.com/forums/en-US/sharepointcustomization/thread/47453851-3acf-40e2-b848-4afb57645746/

http://www.sharepoint-tips.com/2008/06/access-denied-when-trying-to-open-site.html

http://michael.wilcox.net/2008/04/11/logging-into-sharepoint-designer/