This will be a collection of articles or tools I find useful when it comes to potential deployment issues in a SharePoint 2010 environment. I'll continually update it as I find new things!
- Certain folders may have to be excluded from antivirus scanning when you use a file-level antivirus program in SharePoint: http://support.microsoft.com/kb/952167
- SharePoint Dispose Checker Tool: http://archive.msdn.microsoft.com/SPDisposeCheck
- Monitoring and Maintaining SharePoint Server 2010: http://technet.microsoft.com/en-us/library/ff758658.aspx
- Designing pages for quicker downloads: http://technet.microsoft.com/en-us/library/hh206324.aspx
- SQL Database '<contentDBName>' on SQL Server instance '<SQLServer>' not found. Additional error information from SQL Server is included below. Cannot open database "<contentDBName>" requested by the login. The login failed. Login failed for user '<excelServicesAppProcessAccount>'.: http://support.microsoft.com/kb/981293