Customize SSRS extension settings in SharePoint Integrated Mode

SQL Server Reporting Services (SSRS) is powerful way of presenting reports and data to your end users in SharePoint. But sometimes, the out of the box experience of some features of SSRS doesn’t work for your situation. A nice example of this is the field delimiter for CSV exports. This is by default a comma. But… Continue reading Customize SSRS extension settings in SharePoint Integrated Mode

Process items in a Drop Off library using PowerShell

Everyone knows the Drop Off library in SharePoint, right? It routes documents to a final destination, based on rules you define. This works OK for documents which are uploaded manually to the Drop Off library but I found out that it doesn’t work for documents which are uploaded with PowerShell (or any other method which… Continue reading Process items in a Drop Off library using PowerShell

Close disconnected remote sessions using PowerShell

Do you know this situation? You are responsible for some servers and you planned to do some patching during the weekend. You open a remote desktop to the server with the administrator user and you see that the session is still active. Visual Studio is open with unsaved source code, some config files are open, even… Continue reading Close disconnected remote sessions using PowerShell

Configure Object Caching accounts using PowerShell

If you want your Object Caching to work properly in SharePoint, you need to set 2 user accounts: Portal Super Reader Portal Super User Additionally, they must be configured correctly. That is, you need to do 2 things: Add a “Full Control” user policy to your web application for the Portal Super User and use… Continue reading Configure Object Caching accounts using PowerShell

Enabling BLOB Cache in SharePoint using PowerShell

One of the ways of improving performance of your SharePoint is by enabling the BLOB Cache. The BLOB cache is a disk-based cache that stores binary large objects (BLOB’s) on the web server to reduce the load on the database server by avoiding unneccessary round trips to that server. Read all about it on TechNet. The BLOB Cache… Continue reading Enabling BLOB Cache in SharePoint using PowerShell

Creating Managed & Crawled Properties using PowerShell

Have you ever created and mapped a decent amount of managed properties in SharePoint using the UI? If you have, you probably know that it’s not the most exciting job. Lots of clicking, waiting, reloading,… If you are someone like me… someone who doesn’t like doing things manually… and you are reading this, you are… Continue reading Creating Managed & Crawled Properties using PowerShell

Fix variation labels with a wrong locale

Last week, I was doing some support for a customer which had some issues with variations on their intranet which is based on SharePoint 2010. They have 3 variations: English (Source) Dutch French While investigating an issue, I started playing around with the browser language and noticed the following  : Browser language = English => Redirect to… Continue reading Fix variation labels with a wrong locale

Get sites, webs, lists and number of items with their permission inheritance in SharePoint

Working with permissions in SharePoint can become complicated very quickly. Especially when you are starting to break the inheritance on several levels. Finding out which sites and lists have their inheritance broken is a task which can set you back a few hours, depending on the size of your SharePoint environment. Since I’m always short… Continue reading Get sites, webs, lists and number of items with their permission inheritance in SharePoint