[SharePoint 2010] Web Analytics: Monitors the health of the Report Consolidator component

When the SharePoint Web Analytics Service Application takes longer than five hours to process the Health Monitor will report the “Web Analytics: Monitors the health of the Report Consolidator component” for review. It offers the following explanation: With the following suggested remedy: The provided link instructs on how to reduce the amount of records processed, […]

[SharePoint 2010 / SQL Server 2008] Query the SharePoint Object Model from a .NET SQL Server CLR Function

There are times when there is some SharePoint list data that needs to be accessed from a SQL Server query. However, it is unsupported by Microsoft to query the SharePoint Content Database directly and doing so can cause performance or other issues. The question then becomes: How do you query SharePoint data from SQL without […]

[SharePoint 2010] Debugging a Custom SharePoint Timer Job

When creating custom SharePoint timer jobs in Visual Studio 2010 you cannot debug the timer job like you would a web part or application page by simply hitting F5 or the Debug button. Instead, you have to deploy the project to your local SharePoint instance and then attach the debugger to the SharePoint Timer Process. […]

[SharePoint 2010] Set Access Request Email for All SharePoint Sites

I recently needed to set the email address that Access Requests from SharePoint 2010 go to for all sites int the Web Application. Since there is no way to do this in bulk within the interface, I found this blog post outlining a useful PowerScript commant that parses through each SPWeb and sets the Access […]

[ASP.NET / LINQ] Access GridView DataItem Properties of Anonymous Types

I tend to use LINQ for just about everything I can. Many times this involves populating ASP.NET GridViews from code with anonymous types from LINQ. For example: The issue that I came across is that when I need to access data from that query during an OnRowDataBound event. When trying to access the item using […]

[ASP.NET] Multiple Command (Select, Delete, etc.) Fields in a GridView

I recently had the requirement to provide multiple select-type commands on an ASP.NET GridView that each resulted in a different action. Using an only provides you with the ability to have a single select, single delete, and single edit command. You cannot have multiples of each. I did, however, discover the . Using the you […]

[SharePoint 2007/2010] WebDAV Connections Slow (Open With Explorer)

Have you noticed that when you connect to SharePoint via WebDAV or use the Open With Explorer option from a Document Library that it is incredibly slow? There is a very simple fix: Goto Start > Control Panel Select the Internet Options control panel Under the Connections tab, select LAN Settings Uncheck “Automatically detect settings” […]