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! http://msdn.microsoft.com/en-us/magazine/hh547099.aspx

0

SharePoint and Office Web Apps

Office Web Apps is discussed in great detail here:   http://technet.microsoft.com/en-au/library/ff431687.aspx   http://technet.microsoft.com/en-us/office/ee815687.aspx 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…

0

SharePoint – MAXDOP=1

Many, many times I discuss with SharePoint SQL people this issue of Max Degree of Parallelism or MAXDOP. http://technet.microsoft.com/en-us/library/cc298801.aspx#Section6_3 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…

3

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 ‘…

0

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…

0

SharePoint – TempDB and contention

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2009/01/11/tempdb-monitoring-and-troubleshooting-allocation-bottleneck.aspx   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:%’

0

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”

1

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…

0

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  …

1