SharePoint 2013 – enable the Blob Cache
The blob cache (one of four cache types in SharePoint 2013) is a disk based cache to improve the speed at which pages load (it also reduces load on the database server). Enabling this requires editing the web.config file on each…
Backup a service application using PowerShell
If you are making changes to a service application and need to take a backup beforehand this can be done quickly using the Backup-SPFarm cmdlet. Here is an example of how to backup the Managed Metadata service application and proxy:…
Responsive UI for SharePoint 2013/2016 on-premises
If, like me, you have been waiting for a responsive UI for SharePoint 2013, then wait no longer as one has been released! The solution adds support for three different rendering options depending on screen size. It uses embedded CSS…
Disk space filling up on Web Front End servers
I have several web front end servers in a SharePoint 2013 farm and disk space on the C: drive seems to get eaten quite quickly. By using TreeSize I was able to locate a temporary folder used by IE that…
Prevent site collection administrators from upgrading site collections
If you are upgrading from SharePoint 2010 to SharePoint 2013, and you need to prevent site collection administrators from upgrading site collections, then you can disable Self Service Upgrades using the Get-SPSite cmdlet: $portal = Get-SPSite “http://portal.lab.local” $portal.AllowSelfServiceUpgrade = False…
Ensure a purchased app is available in all site collections
I have purchased an app and need to make sure it s available in all site collections within a web application. Firstly I import the app package using the Import-SPAppPackage cmdlet: $spapp = Import-SPAppPackage -Path C:\MyApp.spapp -Site http://portal.lab.local -Source Marketplace Then…
PowerShell script to list sites that have a specified feature enabled
The following PowerShell script will enumerate all sites within a Site Collection and report on where a particular feature has been enabled using the Get-SPWeb cmdlet. In the example I am reporting on the SharePoint Server Enterprise Site Features feature…
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…
Access denied by Business Data Connectivity
While creating an external content type in SharePoint Designer 2013 the following error was displayed when adding a connection to an SQL server using an impersonated custom identity: Access denied by Business Data Connectivity This occurred because the user does…