Custom SharePoint Reports using CAML

I've long wondered how the default SharePoint Site Collections reports are created, and finally I came across an article on how this is done. It seems the only thing required, is a CAML query.The following article from the MS ECM blog explains how to create your own reports with a number of examples using CAML queries. Check it out.http://blogs.msdn.com/ecm/archive/2006/11/15/report-rapport.aspxA

Setting up a SharePoint Development Environment

Farm (?) ish environmenthttp://weblogs.asp.net/erobillard/archive/2007/02/23/build-a-sharepoint-development-machine.aspxSingle Machine Environmenthttp://blah.winsmarts.com/2007-10-A_Single_Developers_SharePoint_2007_Development_Environment.aspx

Integrating ASP.NET applications and SharePoint 2007

Link DumpSharePoint 2007 - Built on ASP.NET 2.0MOSS 2007 - Creating an ASP.NET application in the _layouts directory using Visual Studio 2005Application Development on MOSS 2007 and WSS 3.0ASP.NET 2.0 Web Part Infrastructure and SharePoint 2007Write Custom WebParts for SharePoint 2007Using ASP.NET Web Part into MOSS 2007 Web Site

SharePoint databases file location

Typically, for performance, backup and various other reasons, you'll want that the SharePoint databases are not stored in the default locations. Unfortunately, the Central Administration does not allow you to specify the actual file locations to use when it creates the databases.So to be able to specify different locations for the mdf / lsf files, you'll need to create the databases manually

SharePoint Performance Tuning

When you are thinking in terms of large server farms, you'll need to spend some good time tuning your SharePoint setup for performance.Joel Oleson (who else?) has a great post on performance tuning of the application pool settings.Although some people beg to differ on some of these settings. As always, you should always test and tune and see what works best for you.

SharePoint Look and Feel for ASP.NET applications

Ever wondered how to get an ASP.NET application to look like SharePoint? This blog shows you how to do this.Approach 1Approach 2I would recommend Approach 2 rather than approach 1

User Accounts and Rights required for a MOSS Installation

Clayton has posted a great article about accounts required for MOSS installation:"Installing MOSS 2007 in a farm environment requires a few dedicated accounts and can be quite a confusing process. I came across a couple of great resources so I thought I would save you the heart ache and post them here. "http://claytonj.wordpress.com/2007/04/23/moss-2007-setup-accounts/Scroll down for table (

Uploading documents to SharePoint 2007 via a Webservice

Web Service for uploading documents into SharePointhttp://blogs.ittoolbox.com/km/sharepoint/archives/custom-web-service-for-uploading-files-to-sharepoint-13217

Securing SharePoint 2007

Very nice post on securing your SharePoint server, especially if it going to be exposed to the Internet. As taken from the Joel Oleson's blog.More than 25 Tips to Lockdown Your SharePoint EnvironmentThis is not fully comprehensive, but gets you started down the right track. Some of these may not apply.1. Configure Firewall Rules lock down to most restrictive w/ acceptable level of usability

BI and KPIs in Analysis Services 2005

Nice introductory article to Business Intelligence and KPIs in Analysis Services 2005http://www.databasejournal.com/features/mssql/article.php/10894_3604206_1