Increase list view threshold from 5000 items
By default SharePoint lists are throttled with a threshold of 5000 items. This is mainly to prevent a drain on resource and performance decrease: Whilst not recommended for production environments it is possible to increase this value in Central Administration. …
Show the SharePoint document version inside a Word document
If versioning is enabled on a document library it is possible to show the SharePoint document version inside a Word document (rather than maintain the version inside the Word document manually). It involves configuring a label in the Document Library…
Using the Merge-SPLogFile cmdlet
The Merge-SPLogFile cmdlet can be a real time saver if you need to search the SharePoint logs and there are multiple servers in the farm. I regularly use it to search for a specific correlation ID and then open the…
Rename a Service Application’s database using PowerShell
While setting up a SharePoint 2013 DR environment I needed to script the renaming of databases used by service applications. Utilising the Get-SPServiceApplication cmdlet I was able to achieve this with just three lines: $sa = Get-SPServiceApplication -Name “Managed Metadata…
SharePoint 2013 – hide the page name
Sometimes I find that the page name at the top of a page in SharePoint gets in the way, especially on wiki pages: This can be hidden using some custom CSS in a Script Editor web part: <style>#DeltaPlaceHolderPageTitleInTitleArea{ display: none;…
SharePoint 2013 – create a new eDiscovery Centre
An eDiscovery site can be used to search for, preserve and export content in SharePoint, Exchange or Skype for Business (formerly known as Lync). To create a new site collection for eDiscovery just follow these simple steps: Log in to…
Create a new site template
Creating new sites from a template can be a real time saver, especially if you want them all to have the same layout or include specific content (such as folder structure, document templates, etc). Creating a new template takes only…
SharePoint 2013 – create an external content type for SQL Server
I am creating an external content type to display records from an SQL table in a SharePoint list, using a target application in the Secure Store for authentication. I will do this using SharePoint Designer 2013. At a minimum, I…
SharePoint 2013 – prevent users from purchasing or installing apps from the SharePoint store
If you have created an app catalog, but don’t want users to be able to purchase or install apps from the SharePoint Store, this can be configured in a few simple steps: Log in to Central Administration as a farm…
SharePoint 2013 – AutoSPInstaller hangs at "Creating Metadata Service Application…"
I have noticed several times when using AutoSPInstaller that it hangs at “Creating Metadata Service Application”. So far I haven’t managed to work out why this happens, but the only workaround I have found is to close the PowerShell window…