Find and Delete Orphaned Site Collections in SharePoint

Orphaned Site Collection in SharePoint Orphaned sites are broken sites created in situations like restore interrupt/failure. Often, sites without parent site reference, lists or libraries without site is referred as orphans in SharePoint. These objects are with broken relationship and should be deleted from SharePoint content databases prior to upgrade. During a…

Read more

Host Named Site Collections in SharePoint

What is Host Named Site collection? Host-named site collections are the best option if you want to create multiple root-level site collections within a web application. (Or Unique URL for each site collection). SharePoint supports both path-based & host-named site collections. The primary difference is: All path-based site collections in a Web…

Read more

How to delete a File from SharePoint Document Library using PowerShell?

Requirement: Delete a file from SharePoint document library using PowerShell PowerShell to delete a file from document library: At times, you may have to delete a particular file from a library. In one of my cases, as part of a deployment, before copying certain files, I had to check whether the particular…

Read more

Build SharePoint 2010 Farm without Database GUIDs

When setting up SharePoint, often its an annoyance from DBAs perspective, SharePoint adds GUIDs with Database names. Is there a way to build without GUIDs? Yes, PowerShell is your friend. Here is how: For Configuration Database: Once the installation is over, uncheck the “Run Product & technologies configuration wizard” checkbox. Fire the PowerShell…

Read more

How to Hide User Names in Created by, Modified by Fields in SharePoint?

Requirement:  Had to provide complete anonymous entries in SharePoint task list by masking user names (as in SharePoint Surveys). Here is the Trick: There is a Property for SharePoint List, called “ShowUser”. we can set that to “False” using PowerShell or C# object model. PowerShell script to Hide User Names in SharePoint:…

Read more

SharePoint Datasheet view in Read-only mode? Try these Solutions

Issue: In Datasheet sheet view, users unable to edit anything. Its in always Read-Only mode. Solution: Check the following to fix SharePoint list in datasheet view is read only: Content Approval must be turned OFF (Microsoft KB: https://support.microsoft.com/kb/2274841) Some columns are dependent on Microsoft Access, check whether MS-Access is installed in the client…

Read more

Opening/Saving Documents in SharePoint is Very Slow – Solution

Recently, an end-user reported the issue: Opening/Saving Office 2007 Documents to MOSS 2007 is very slow.  Here is his detailed complaint: “Often at work, I sometimes receive a message after 10 minutes or so that ‘Excel Is not responding’ in the upper corner of the screen. When this happens, the document is…

Read more