SharePoint / Office 365 / Azure Blog

  Configure data access account - Log on to AD server, and create an account to access data source. Example: ExcelODCAccess Grant Read access to data source Set the Db_datareader to data source Configure Secure Store Services In the Secure Store target application, we will map a specific AD Group to the ExcelODCAccess account, Excel Services will use this account on their behalf to refresh data-connected workbooks. - Create an AD Group on AD Server, example: ExcelODCAccessGroup - Add accounts to this AD Group: User1, User2 Create a target Application on Secure Store Services - Open SharePoint 2010 Central Administration –> Application Management –> Manage Service Applications - Open Secure Store Service - New - Configure New Secure Store Service Target Application - Next Associate the account (ExcelODCAccess) use to access data source to Target Application - Set Credentials Create and publish an ODC file - Open Excel 2010 from a client PC and create a connection to ...

  Ref: http://office.microsoft.com/en-us/windows-sharepoint-services-help/examples-of-common-formulas-HA001160947.aspx

  Great SharePoint Performance Series: Top 5 SharePoint Performance Mistakes http://blog.dynatrace.com/2010/03/18/how-to-avoid-the-top-5-sharepoint-performance-mistakes/ Using Batch-Updates to speed up performance http://blog.dynatrace.com/2009/01/20/sharepoint-using-batch-updates-to-speed-up-performance/ Identifying memory problems introduced by custom code http://blog.dynatrace.com/2009/02/12/sharepoint-identifying-memory-problems-introduced-by-custom-code/ List Performance – How list column indices really work under the hood http://blog.dynatrace.com/2009/01/28/sharepoint-list-performance-how-list-column-indices-really-work-under-the-hood/ List Performance – How list column indices really work under the hood http://blog.dynatrace.com/2009/01/22/sharepoint-monitoring-individual-list-usage-and-performance/ And more… http://blog.dynatrace.com/page/2/?s=SharePoint

http://technet.microsoft.com/en-us/sharepoint/hh126809

  http://msdn.microsoft.com/en-US/sharepoint/fp123633

  Get the power of XSL Link   Ref: http://stefan-stanev-sharepoint-blog.blogspot.com/2010/08/xsltlistviewwebpart-several-xslt-tips.html http://maulikdhorajia.blogspot.com/2011/06/sharepoint-2010-xsltlistviewwebpart.html Problem http://blog.vossers.com/2012/01/28/how-the-xsltlistviewwebpart-in-sharepoint-2010-can-be-a-real-performance-killer/ Hotfix: http://support.microsoft.com/kb/2598348

Ref: http://social.technet.microsoft.com/wiki/contents/articles/1262.test-lab-guides-en-us.aspx

  You can find  the SharePoint Content Database of SharePoint Site Collection via SPSite.ContentDatabase that is a SPDatabase object. Via SPDatabase object, you have DatabaseConnectionString and LegacyDatabaseConnectionString that used to connect to SharePoint Content Database http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spsite.contentdatabase.aspx http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.administration.spdatabase_members http://blog.tylerholmes.com/2009/02/how-sharepoint-found-its-content.html

  http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011?sort=sequential&direction=desc&term=&t=office%2B-and-%2Bsharepoint

http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/cfb48d3a-2d6e-4fbb-88be-ed73b2caa92e http://neganov.blogspot.com/2011/08/custom-alerts-in-sharepoint-templates.html   http://blogs.msdn.com/b/sharepointdeveloperdocs/archive/2007/12/07/customizing-alert-notifications-and-alert-templates-in-windows-sharepoint-services-3-0.aspx http://blogs.msdn.com/b/sharepointdeveloperdocs/archive/2007/12/14/how-to-customizing-alert-emails-using-ialertnotificationhandler.aspx http://blogs.syrinx.com/blogs/sharepoint/archive/2008/04/28/custom-alert-handlers-part-1-of-2.aspx http://support.microsoft.com/kb/948321

Ref: http://msdn.microsoft.com/en-us/library/dd304243%28PROT.13%29.aspx Ref: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spbasepermissions.aspx Ref: http://ralessi.wordpress.com/2010/12/09/core-js-customization   Example: HasRights(0×0, 0×800) 0×0—> Empty mask              0×800—> Manage Lists   The values of the permission mask bits are specified as follows. Symbolic name Value Description EmptyMask 0x0000000000000000 Grant no permissions. FullMask 0x7FFFFFFFFFFFFFFF Grant all permissions. The   list   and   document   permissions (0x000000000000XXXX) are specified as follows. Symbolic name Value Description ViewListItems 0x0000000000000001 Allow viewing of   list items   in lists, documents in   document libraries , and   Web discussion   comments. AddListItems 0x0000000000000002 Allow addition...