Use SQL Server Reporting Services against a SharePoint List as data

Wow let's try it and please let us all know.

found on
Robert Shelton's Blog
http://rshelton.com/archive/2008/12/11/how-to-use-sql-server-reporting-services-against-a-sharepoint.aspx

by Andy Searls
http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx

Plan for software boundaries (Office SharePoint Server)

From technet.microsoft.com

Estimate performance and capacity requirements (Office SharePoint Server),Plan for software boundaries (Office SharePoint Server).

This article provides information to help you understand the tested performance and capacity limits of Microsoft Office SharePoint Server 2007, provides information about the test environment and test results, and offers guidelines for acceptable performance. Use the information in this article to determine whether your planned deployment falls within acceptable performance and capacity limits.

http://technet.microsoft.com/en-us/library/cc261716.aspx

http://technet.microsoft.com/en-us/library/cc262787.aspx

Enhancing the SharePoint sites

Those links below are related to enhancing the SharePoint sites, caching, disposing objects and all about memory leaks, optimize SharePoint sever indexing, enhancing camel quires, content query web parts and such and such.

Blob cache:
http://office.microsoft.com/en-us/sharepointserver/HA101762841033.aspx

IIS compression:
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/d52ff289-94d3-4085-bc4e-24eb4f312e0e.mspx?mfr=true

SharePoint best practices:
http://msdn.microsoft.com/en-us/library/aa973248.aspx

Configure page output cache settings:
http://office.microsoft.com/en-us/sharepointserver/HA101206861033.aspx

MSDN References:
http://msdn2.microsoft.com/en-us/library/aa973248.aspx
http://msdn2.microsoft.com/en-us/library/bb687949.aspx
http://msdn2.microsoft.com/en-us/library/aa973248.aspx
http://msdn.microsoft.com/en-us/library/ms413145.aspx?PHPSESSID=7c61ntavm1dmu84rl10kephll5
http://msdn.microsoft.com/en-us/library/aa505327.aspx
http://msdn.microsoft.com/en-us/library/ms947783.aspx
http://msdn2.microsoft.com/en-us/library/bb727371.aspx#MOSS2007OptPerfWCM_OverviewofPerformanceOptimizationforWCMSites

Forums, blogs, articles and other websites:
http://www.binarywave.com/blogs/eshupps/Lists/Posts/Post.aspx?List=9c93c708%2De5ce%2D4714%2Dbdea%2D499330361130&ID=111
http://blogs.technet.com/stefan_gossner/archive/2007/11/26/dealing-with-memory-pressure-problems-in-moss-wss.aspx
http://blogs.msdn.com/joelo/archive/2007/12/05/10-things-to-optimize-your-sharepoint-server-indexing.aspx
http://www.ranjanbanerji.com/techtalk/20070716.aspx
http://blogs.msdn.com/tess/archive/2006/09/06/net-memory-usage-a-restaurant-analogy.aspx
http://support.microsoft.com/default.aspx/kb/933560
http://jritmeijer.spaces.live.com/blog/cns!8A48A27460FB898A!965.entry?wa=wsignin1.0

Violation of PRIMARY KEY constraint 'PK_OrderForms'. Cannot insert duplicate key in object 'dbo.OrderForms'

This may happens because a multiple users logging in and checking out under the same userid/password at the same time so same basket this may cause a corrupted basket,

any way find the solution here !

http://social.msdn.microsoft.com/Forums/en-US/commserver2007/thread/898b5886-cb62-44d6-b64b-de719faf5b84/

Anonymous Search Results

there is one page that is absolutely necessary for everyone to access: osssearchresults.aspx. This page presents the list of search results.

By default, viewing this page requires a user to be authenticated to the server. This can create a problem when your site definition includes the basic search control as it will attempt to render all search results on this page with Anonymous access.

locate the following text at the top of the osssearchresults.aspx (inside the < % @ Page ... /> declaration) and remove it:Inherits="Microsoft.SharePoint.WebControls.LayoutsPageBase"This setting determines the inheritance of the page from the generic application page base class; however, it is not required for the page to function. Anonymous uers will be able to view the page without having to login and search results will continue to be security trimmed so users without proper permissions will be unable to view restricted items.

this is from The SharingPoint it works fine and here you are the link below.

http://sharingpoint.blogspot.com/2007/05/anonymous-search-results-in-wss-v3.html

Anonymous impersonation for FBA portals in SharePoint

We all get used to grant IUSER_computername any access we need as IUSER is the internet users that all anonymous user are impersonating when they try to access any page in your portal, and it works for only windows authentication. To do the same thing but with forms based authentication you need to
1- Store or register your IUSER for example guest to your membership repository.2- Grant that guest any access rights you want inside or outside SharePoint.3- Write some code to make all unauthorized users impersonate that guest inside the portal 'Global.asax'. which is protected void Application_AuthenticateRequest(Object sender, EventArgs e) { string cookieName = FormsAuthentication.FormsCookieName; HttpCookie authCookie = Context.Request.Cookies[cookieName]; if (authCookie == null) { FormsAuthentication.SetAuthCookie("guest", false); } }So all the anonymous users will have a guest access 'your created guest' on your portal
For more details see the link below.
http://blogs.devhorizon.com/reza/?p=508

shrinking SQL database log file

use master
go

ALTER DATABASE urDataBaseName SET RECOVERY Simple --to alter the database to simple mode to accept shrinking

BACKUP LOG urDataBaseName WITH TRUNCATE_ONLY --to backup the log file before shrinking

use urDataBaseName
go

DBCC SHRINKFILE (urDataBaseName_log, TRUNCATEONLY) --shrinking the log

use master
go

SELECT * FROM sys.dm_tran_session_transactions --check on the operation

ALTER DATABASE urDataBaseName SET RECOVERY Full --reset first line

-- and if it gives you an error says cannot locate file urDataBaseName_log in sysfiles ... It could be an issue with the logical file name so make sure that the logical file name is as the physical file name.