Here are a list of references for those interested in setting up, configuring, operating and managing a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode. If there's any area needing more attention or references, please add those topics to the comments below. Thanks for choosing Microsoft.

Does SharePoint integrated mode fit your requirements? (What features are Not supported? To which server in the farm should we add SSRS? etc.)
Features Supported by Reporting Services in SharePoint Integration Mode at http://msdn2.microsoft.com/en-us/library/bb326290.aspx

Reporting Services and SharePoint Technology Integration at http://msdn.microsoft.com/en-us/library/bb326358.aspx

Setup and Configuration (Should we install Reporting Services on the SQL box? And answers to other such questions)
How to: Configure SharePoint Integration on Multiple Servers at http://msdn.microsoft.com/en-us/library/bb677365.aspx
How to: Configure SharePoint Integration on a Standalone Server at http://msdn2.microsoft.com/en-us/library/bb677368.aspx
(To pass SharePoint token or Kerberos token; whether stored credentials is enough for report data sources or integrated windows is a requirement)
Security Overview for Reporting Services in SharePoint Integration Mode at http://technet.microsoft.com/en-us/library/bb283324.aspx
Identity delegation for SQL Server Reporting Services (SharePoint Server 2010) http://technet.microsoft.com/en-us/library/gg502598.aspx

Working with Report Server items on a SharePoint site
Working with Report Server Items in a SharePoint Site (Reporting Services in SharePoint Integrated Mode) http://technet.microsoft.com/en-us/library/bb283321.aspx
Viewing and Managing Report Server Items from a SharePoint Site http://technet.microsoft.com/en-us/library/bb326347.aspx
How to: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode) http://msdn.microsoft.com/en-us/library/bb326289.aspx
Granting Permissions on Report Server Items on a SharePoint Site http://technet.microsoft.com/en-us/library/bb326215.aspx

Setting Processing Options
How to: Set Processing Options (Reporting Services in SharePoint Integrated Mode) http://technet.microsoft.com/en-us/library/bb283188.aspx
Caching Reports (SSRS) - http://technet.microsoft.com/en-us/library/ms155927.aspx
For more information about cache refresh plans, see Scheduling Reports, Shared Datasets, and Subscriptions
Caching Shared Datasets (SSRS) - http://technet.microsoft.com/en-us/library/ee636149.aspx
Creating, Modifying, and Deleting Snapshots in Report History http://technet.microsoft.com/en-us/library/ms156325.aspx
How to: Create Report History (Reporting Services in SharePoint Integrated Mode) http://technet.microsoft.com/en-us/library/bb326416.aspx

Use the Reporting Services web part
Report Viewer Web Part (Reporting Services in SharePoint Integrated Mode) http://technet.microsoft.com/en-us/library/ee210703.aspx
How to: Add the Report Viewer Web Part to a Web Page (Reporting Services in SharePoint Integrated Mode) http://technet.microsoft.com/en-us/library/bb326362.aspx
Using the Report Viewer Web Part on a SharePoint Site http://technet.microsoft.com/en-us/library/bb522800.aspx
How to: Connect Filter or Documents Web Part (Reporting Services in SharePoint Integrated Mode) http://msdn.microsoft.com/en-us/library/bb283248.aspx (we can use the Web Part page option; we have to enable popup; when we select Connection on the Text Filter, we specify outgoing connection – it is not complete till the popup dialog shows the report parameter option to bind the connection; for the scenario of using one web part to show multiple reports, the Incoming connection of the report viewer web part could be used when the page has the other web part showing the reports available)

Programming against the end point
SharePoint Proxy Endpoints section of http://msdn.microsoft.com/en-us/library/ms155398.aspx can be referred

Hope this is useful for those working with SQL Server Reporting Services in SharePoint integrated mode.