SharePoint Dragons

Nikander & Margriet on SharePoint

Category Archives: Uncategorized

SharePoint versions, Service Packs or Cumulative Updates

The following blog post from Todd Carter contains links to all the SharePoint versions, available Service Packs and CUs: http://todd-carter.com/page/SharePointVersions.aspx.

Managing SharePoint 2010 log files

A nice link that discusses dealing with SharePoint 2010 database transaction log files:

http://technet.microsoft.com/en-us/library/ff621098.aspx

Which features do I need to activate in SharePoint 2010?

As you all know it can be difficult to find out which feature you have to activate before you’re able to do something. Eventually it would be nice if this Wiki page becomes an authoritive resource for this topic.

http://social.technet.microsoft.com/wiki/contents/articles/7341.which-features-do-i-need-to-activate-in-sharepoint-2010.aspx

Output cache in SharePoint 2010

Have you been in a situation where you wanted to use the site collection output cache but couldn’t find it?

To start using the site collection output cache you have to activate the following features:

  • SharePoint Server Publishing Infrastructure (site collection)
  • SharePoint Server Publishing (site)

More information about Output Caching and Cache Profiles in SharePoint Server 2010 can be found here: http://msdn.microsoft.com/en-us/library/aa661294.aspx

SharePoint 2007 to 2010 migration

The ideal starting point for doing a migration to SPS 2010: http://technet.microsoft.com/en-us/sharepoint/ee517214

Little InfoPath trick

Place two buttons on an InfoPath form, and give the first button the label ‘5’ and the second button the label’ ‘6’. Then select both buttons and select the font Marlett. The labels 5 and 6 will be replaced with arrows.

image

Leveraging the logging database to see performance counters

SharePoint Server 2010 ships with a logging database (default name: WSS_Logging). You can make sure information gets added into it by opening SharePoint Central Administration > Monitoring > Timer Jobs > Review Job Definitions and enable or run all timer jobs starting with “Diagnostic Data Provider”.

After that, if you want to take a look at the performance counters, you can use the PerformanceCounters view in the logging database. Since it only shows counterid’s, the view in itself is not very helpful unless combined with information coming from the PerformanceCountersDefinitions table that includes the path and the instance name of the performance counters, like this:

SELECT TOP 1000 [PartitionId]
      ,[RowId]
      ,[LogTime]
      ,[MachineName]
      ,[CounterId]
      ,[Value]
      ,[RowCreatedTime]
      , pd.counter
      , pd.instance
  FROM [WSS_Logging].[dbo].[PerformanceCounters]
  join [WSS_Logging].[dbo].[PerformanceCountersDefinitions] pd ON counterid = pd.id