SharePoint – Custom Claims-Based Security

A fascinating read. A “Contoso” site called “ContentWeb” sounds like “a “HR” kind of web site. Shows you how to secure based on A and B and C etc. instead of the standard A or B logic. Plenty of places could leverage these ideas!

SharePoint and Office Web Apps

Office Web Apps is discussed in great detail here: HOWEVER, the hardest thing was to find out where the Office Web Apps component is hiding, so that we could install onto a new farm.TechNet just says go to the Volume Licensing Center, but fails to say what to look for! So the…

SharePoint – MAXDOP=1

Many, many times I discuss with SharePoint SQL people this issue of Max Degree of Parallelism or MAXDOP. states pretty clearly, that “To ensure optimal performance, we strongly recommend that you set max degree of parallelism (MAXDOP) to 1 SQL Server instances that host SharePoint Server 2010 databases. ” this has been tested pretty…


SQL – dammit it’s in there somewhere!

# I wanted to find ALL references to a particular string (domain\user) and I had no idea WHERE it might be.# so how do you ask SQL to go look everywhere and report back?# like this… DECLARE @searchValue varchar(100)SET @searchValue = ‘domain\username’SELECT  ‘select ”’ +  table_schema +  ‘.’ + TABLE_NAME +  ‘.’ + COLUMN_NAME +  ”’ from ‘…

SharePoint – export Solutions?

Discussing DR issues and dependancy’s etc., I was pondering features and solutions and it struck me that if one has LOST the pre-packaged solution during a DR, how could one extract it from Config? Turns out to be dead easy…    # tell powershell to load Sharepoint DLL’s[void] [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”)[void] [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.Office.Server”)[void] [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.Office.Server.Search”)[void] [System.Reflection.Assembly]::LoadWithPartialName(“Microsoft.Office.Server.Administration.ServerFarm”)## connect to the…

SharePoint – TempDB and contention   One key point is that the contention mentioned below and in the article can be identified by running the following query against the SQL instance in question: SELECT session_id, wait_duration_ms, resource_description       FROM    sys.dm_os_waiting_tasks       WHERE   wait_type like ‘PAGE%LATCH_%’ AND       resource_description like ‘2:%’

SharePoint – web usercount

# Purdon, god of SharePoint things# recently sent me this tid-bit for when you are considering # how many licenses you might need, this info might be useful! $SPUserCollection = $SPweb.AllUsers$UserCount = $SPUserCollection.Countwrite-output ” Users in WEB: $UserCount”


SharePoint and Large Lists

# a colleague recently posted an incredibly useful bit of code# which can show us those potentially problematic Large Lists.# enjoy! param( $PathToSitesFolder = “.” ) function fnLargeListsFromSubWebs {param( [Parameter(ValueFromPipeline=$true,Mandatory=$true)] $ParentWeb )    process { $largeLists = $ParentWeb.SPListCollection.SPList | ? { [int] ($_.ItemCount) -ge 2000 } if ($largeLists) {  $largeLists | % { $_ | Add-Member -MemberType NoteProperty -Name…

SharePoint Regional Settings in Powershell

# my friend Purdon is a SharePoint God of note# and he reminded me of a problem that crops up occasionally# when dealing with TZ’s and Languages# here is his Powershell to correct a Language for a Site#param ([string] $SiteCol = $(throw “The Site Collection URL is required.”))  #throw exception if no value provided  …