Attachments using MailMessage

http://www.c-sharpcorner.com/Blogs/10117/send-email-with-multiple-attachments-in-sharepoint-2010.aspx

How does the "Commit pending changes" action work and when is it best used?

http://connect.nintex.com/forums/thread/7827.aspx

Limitations of External Lists

http://salaudeen.blogspot.de/2012/03/limitations-of-external-lists-in.html

http://sharepointmike.wordpress.com/2011/03/02/10-things-you-cannot-do-with-an-external-list/

All About Nintex

http://www.vadimtabakman.com

Understanding Developer Dashboard

http://www.cnblogs.com/csts/archive/2012/04/19/2457244.html

Developer Dashboard SharePoint 2010 | SharePoint Boco

Developer Dashboard « Extreme Sharepoint

http://www.topsharepoint.com/enable-developer-dashboard-in-sharepoint-2010

Learning SSRS

http://smallbusiness.chron.com/displaying-ssrs-report-sharepoint-35384.html
http://fendy-huang.blogspot.de/2011/02/create-ssrs-report-with-sharepoint-2010.html


http://intellisoft.wordpress.com/2012/02/20/working-with-reporting-services-in-sharepoint-2010/
http://www.codeproject.com/Articles/88285/Integrating-Sharepoint-2010-and-SQL-Reporting-Serv

Architecture: http://www.accelebrate.com/sql_training/ssrs_tutorial.htm

Videos: http://www.youtube.com/user/bilessons?feature=results_main

Exception Handling - Best Pratices

http://www.codeproject.com/Articles/9538/Exception-Handling-Best-Practices-in-NET 

Overview of using fine-grained permissions

Item Level Permissions and Performance:

http://anilmukka.wordpress.com/2011/05/05/overview-of-using-fine-grained-permissions/
http://e-junkie-chronicles.blogspot.de/2011/03/sharepoint-2010-performance-with-item.html
http://e-junkie-chronicles.blogspot.de/2011/03/sharepoint-2010-performance-with-item_23.html

Query to fetch list item counts from Content DB

Returns the count of items in all lists in a web application:



select [***].[dbo].[AllWebs].Title,[***l].[dbo].[AllWebs].FullUrl, tp_Title,tp_ServerTemplate,UserDataCount,DocsCount
from [***].[dbo].[AllLists] left outer join
(select tp_ListId, COUNT(*) as UserDataCount from [***].[dbo].[AllUserData]
group by tp_ListId ) E On E.tp_ListId = AllLists.tp_ID
left outer join
(select ListId, COUNT(*) as DocsCount from [***].[dbo].[AllDocs]
group by ListId ) P ON AllLists.tp_ID = P.ListId
left outer join [***].[dbo].[AllWebs] ON AllLists.tp_WebId = [***].[dbo].[AllWebs].Id
order by DocsCount desc

Best Practices: Common Coding Issues When Using the SharePoint Object Model

http://msdn.microsoft.com/en-us/library/bb687949(v=office.12).aspx

Working with AllowUnsafeUpdates()

Working with AllowUnsafeUpdates()

http://hristopavlov.wordpress.com/2008/05/16/what-you-need-to-know-about-allowunsafeupdates/
http://hristopavlov.wordpress.com/2008/05/21/what-you-need-to-know-about-allowunsafeupdates-part-2/

Page - Best Practices

http://www.aspfree.com/c/a/ASP.NET/ASP.NET-Life-Cycle-and-Best-Practices/

Debug vs Release Mode DLL

http://novatecno.blogspot.de/2010/04/increase-sharepoint-performance-retail.html

What's in the Temporary ASP.NET Folder?

Here - http://msdn.microsoft.com/en-us/magazine/cc163496.aspx

SharePoint Logs

How do I troubleshoot SharePoint? So many logs!

Timer Jobs in SharePoint

Step - By - Step Procedure
Andrew Connell's Post
Timer Scope and Lock

SPSecurity.RunWithElevatedPrivileges

The ideal way to Elevate Privileges:

(Code written on the run - Check for build errors)

Guid SiteID = SpWeb.Current.Site.ID;
Guid WebID = SPWeb.Current.Web.ID;

SpSecurity.RunWithElevatedPrivileges(delegate(){

using (SPSite oSite = new SPSite(sSiteID))
{

              using (SPWeb oWeb = oSite.OpenWeb(WebID))

               {

                             //Logic

                }

}
});

One thing to be kept in mind while implementing such logic is that any SP Object with is created outside of the RWEP belongs to that particular context and when that SP Object is sent inside the RWEP, the elevation is lost.

For Example, if I need to use a list within the RWEP, then I should follow these:

DoSomethingWithTheList(SPList tempList)
{
    Guid SiteID = SpWeb.Current.Site.ID;
    Guid WebID = SPWeb.Current.Web.ID;
    string sListName = tempList.Title;

    SpSecurity.RunWithElevatedPrivileges(delegate()  
   {
        using (SPSite oSite = new SPSite(sSiteID))
       {

            using (SPWeb oWeb = oSite.OpenWeb(WebID))

           {
                 SPList oList = oWeb.Lists.TryGetList(sListName);

                 //Logic

           }

       }
   });
}

Understanding Sessions

Good Read:

ASP .NET State Management

Enabling Sessions

How to enable sessions in a SharePoint Web Application:

Open the web.config file of your web application and do the following:

Locate the <modules> section, and just below <remove name="Session" />, add a new element:

 <add name="Session" type="System.Web.SessionState.SessionStateModule" preCondition="" />

Then, locate the <pages> element and enable session state:

    <pages enableSessionState="true" ...

Enable or disable session state across the entire farm


On the taskbar, click Start, point to Administrative Tools, and then click SharePoint 3.0 Central Administration.
In the top navigation bar, click the Application Management tab.
On the Application Management page, in the Office SharePoint Servers Shared Services section, click Configure session state.
On the Configure Session State page, in the Enable Session State section, select the Enable Session State check box to enable session state for the farm.
To specify the duration of sessions, in the Timeout section, enter a number (in minutes) in the Session should be timed out after (minutes) box. The default is 60 minutes.
Click OK to save the session state configuration.

CSS Tutorials

http://www.instantshift.com/2009/01/11/30-excellent-css-based-navigation-and-buttons-tutorial/

http://speckyboy.com/2009/05/27/22-css-button-styling-tutorials-and-techniques/

http://free-buttons.org

http://www.pagetutor.com/button_designer/index.html

Get Hex Codes of Colors