SharePoint folder deletion error: Cannot delete/checked out issue

Recently I have seen an issue where user was unable to delete a folder in a SharePoint online document library because a file was checked out for editing by a user. An in folder there was not file with pending checkout. And mandatory checkout was disabled on the document library. Solution: There were mandatory fields …

Continue reading ‘SharePoint folder deletion error: Cannot delete/checked out issue’ »

Add/Remove Administrative Access on a Site Collection

There are three ways to change the administrative access for a site collection. Go to SharePoint Site Collection settings and click on Site Collection Administrators link under Users and Permissions. On this screen you can add/remove a user for assigning or removing site collection administrative access for a user. You can also follow this step …

Continue reading ‘Add/Remove Administrative Access on a Site Collection’ »

SharePoint Post Migration Comparison Report to Verify Migrated content using PowerShell

Being involved in migrations for past couple of years, one of the pain area is to verify the migrated content. There are some amazing migration tools like Sharegate, Metalogix, AvePoint and they provide some very useful reports to verify the content but still I haven’t seen a report which can compare the migrated content in …

Continue reading ‘SharePoint Post Migration Comparison Report to Verify Migrated content using PowerShell’ »

Major differences between SharePoint Server 2016 and SharePoint Server 2019

Microsoft is working on cloud first approach which means that the SharePoint Server 2019 will have all the SharePoint online features. SharePoint online supports both Modern and Classic UI, where modern experience is shared on SharePoint server 2019 and classic ui experience is shared on SharePoint Server 2016. Below is a list of difference between …

Continue reading ‘Major differences between SharePoint Server 2016 and SharePoint Server 2019’ »

Adding a Column to list Index using PowerShell and UI

Adding a column to a SharePoint list is pretty simple job, you need Edit permission on the list to update the list column index and also item count in list must be less than 20000 as you can not add a field to list index if item count is over 20K. You can add upto …

Continue reading ‘Adding a Column to list Index using PowerShell and UI’ »

SharePoint Important URLs

Being working on SharePoint for last one decade, I always use shortcut to reach out to different content. Shortcut means typing URLs directly in address bar instead of going through site navigation. My most favorite URLs which I used most are /_layouts/15/viewlsts.aspx and /_layouts/15/settings.aspx. There are couple of important URLs or pages which you need …

Continue reading ‘SharePoint Important URLs’ »

How to create a multiline text field as searchable

This is one of the challenges to SharePoint search content on a list from multiline field. Multi line text field cannot be indexed as it’s an Unsupported Column Type. Indexing the field is separate from search crawling which is needed for search result. Make sure the column has a managed property which allows a column …

Continue reading ‘How to create a multiline text field as searchable’ »

SharePoint listing all documents with versioning detail

Document library in SharePoint shows count of the documents only, but there are many minor and major versions for a document. In this blog post I am going to share how we can generate a report for a document library which have details for all major and minor versions of document version size and checkedIn …

Continue reading ‘SharePoint listing all documents with versioning detail’ »

SharePoint Storage Metrics to Check size of a document Library

SharePoint storage gives us a very useful report to understand the size of a site, sub site, list and library. To view the Storage Metrics report you have to follow simple steps Go to Site Collection Settings –> Site Collection Administration –> Storage Metrics You can drill down the document library or sub site to …

Continue reading ‘SharePoint Storage Metrics to Check size of a document Library’ »

SharePoint Performance Issue- Set Memory Limits on SQL Server

By default, SQL Server is set to use max 2TB of RAM. You might not be having 2TB RAM in your environment, you might have 8GB, 16GB or more depending on your farm and SharePoint installation. Here is a formula to determine memory size for all instances of SQL Server. SQL Max Memory= TotalPhysicalMemory – …

Continue reading ‘SharePoint Performance Issue- Set Memory Limits on SQL Server’ »