Set Max Degree of Parallelism for SharePoint 2013 in SQL Server 2012

What is max degree of parallelism in SQL Server? SQL Server configuration option ‘max degree of parallelism’ limits the number of processors used for the execution of a query with a parallel plan. By default, it’s set to ‘0’ to allow all processors available.  SharePoint 2013 requires that the “max degree of…

Read more

SharePoint Site Collection vs Subsite – Determine Which One to Create

SharePoint newbies often get confused with this question: When to create Site collection and when to use Subsites? What are the advantages of having a Ste collection rather subsite? Well, the choice of Site collection or subsite can be determined based on these factors: Security/Permission Management – Every Site collection uses unique…

Read more

Database is in compatibility range and upgrade is recommended – Solution

Problem:  After a service pack upgrade in SharePoint 2013, database status under  Central Admin >> Upgrade & Migration >> Review database status – turned into “Database is in compatibility range and upgrade is recommended” Solution: In most cases, this message simply means, You have installed the latest patch/service pack, and running SharePoint…

Read more

Solution for “The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered” PowerShell Error in SharePoint 2013

We have a new SharePoint administrator who joined our team. We granted him access to all SharePoint servers, added him to the Farm Admin group, Web application policy.  However, when he tried launching SharePoint Management Shell or try adding the SharePoint PowerShell snap-in from PowerShell ISE, got the error message:  “The local…

Read more

PowerShell “Exception of type ‘System.OutOfMemoryException'”

In middle of a script execution, Got the below error: The following exception was thrown when trying to enumerate the collection: “Exception of type ‘System.OutOfMemoryException’ was thrown.”. At d:\Scripts\VersionRpt.ps1:19 char:16 +         foreach <<<<  ($FileVersion in $File.Versions)     + CategoryInfo          : NotSpecified: (:) [], ExtendedTypeSystemException     + FullyQualifiedErrorId : ExceptionInGetEnumerator Solution: Increase the…

Read more

Find All Site Templates Used by SharePoint Sites

Requirement: Find all Site templates used in a SharePoint 2010 environment and generate report prior proceeding with Migration, as certain templates are discontinued in SharePoint 2013. Solution: Lets get site template usage report on all sites using PowerShell. PowerShell Script to Get Web Templates of all sites and Export to CSV Report:…

Read more

How to Integrate Twitter with SharePoint to Get Twitter Feeds?

Although there are Twitter-SharePoint web parts in CodePlex, we can integrate Twitter with SharePoint with Out-of-the-box script editor/content editor web parts in a few steps. Simply, follow these steps for adding twitter to SharePoint to get twitter feeds. Step 1: Go to https://www.twitter.com and Log-in to your Twitter account.(You need to have…

Read more

Add-SPShellAdmin: You need to have Machine administrator priviliges to run this cmdlet

While trying to add a new user to grant PowerShell script execution policies, Got this error message: Add-SPShellAdmin: You need to have Machine administrator priviliges to run this cmdlet Solution: Although you are in the local server Administrator group, You must run the SharePoint Management Shell as Administrator. Simply right-click on SharePoint…

Read more

Download All Versions of a Document in SharePoint using PowerShell – Web Services

Requirement: Wanted to extract and download each version of the document stored in a SharePoint library. Well, PowerShell can do it from the client side using web services. Here is the PowerShell script to download each version to the local folder programmatically. Download all versions of a document using PowerShell Here is…

Read more

Expand-Collapse All Groups in SharePoint 2013 List Views using jQuery

SharePoint doesn’t have the ability to expand/collapse all groups in grouped list views. However, with jQuery we can bring Expand All-Collapse All buttons in SharePoint 2013 grouped list views. Just edit the grouped view page (Site Actions Gear >> Edit Page), add a “Script Editor” Web part and then place the below…

Read more