Deprecated Features in SharePoint 2019

When we discuss about new features comes up with new SharePoint version then there is also a list of features added to deprecated list. A deprecated feature is no longer being invested in by Microsoft and may be removed in future major releases of SharePoint Server with no additional notice. Below is the list of …

Continue reading ‘Deprecated Features in SharePoint 2019’ »

New Features in SharePoint 2019

The new SharePoint Server 2019 majorly focus on user experiences which is similar to SharePoint Online, and changes in content engagement which can support all browsers and devices (responsive) There are couple of new features added to SharePoint 2019, most of the users already experienced them on SharePoint online for some time now. Below is …

Continue reading ‘New Features in SharePoint 2019’ »

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’ »

Best Practice: SQL Server settings before deploying SharePoint Server

Do not enable auto-create statistics on a server that hosts SQL Server and SharePoint Server. Enabling auto-create statistics is not supported for SharePoint Server. SharePoint Server configures the required settings during provisioning and upgrade. Manually enabling auto-create statistics on a SharePoint database can significantly change the execution plan of a query. We recommend updating the …

Continue reading ‘Best Practice: SQL Server settings before deploying SharePoint Server’ »

SharePoint List Index Column

SharePoint list column added to list index to improve the column performance when filter content as it improves the performance of query operations which can include filters, sorting and joins on index columns. You can add single column index or two column indices for a list. Index column are similar to index column in database, …

Continue reading ‘SharePoint List Index Column’ »

Append changes to track comments in a SharePoint list

You might have seen comments on blogs/wiki page, or you can have seen comments when you checked in or publish a document in SharePoint. These comments are used to track the changes or communication for that change. Similar functionality can be achieved on a SharePoint list, I have seen many companies saving their procurement details …

Continue reading ‘Append changes to track comments in a SharePoint list’ »

SharePoint Online limitations and boundaries

When you are going to work on information architecture for a SharePoint site, you must need to understand the limits and boundaries for the SharePoint version you are using and design site information architecture accordingly. In this blog post I am going to share the limits and boundaries for SharePoint online. Some of the boundaries …

Continue reading ‘SharePoint Online limitations and boundaries’ »

SharePoint Online: Format list columns in modern UI

Customizing a list view was never easily and we used different ways in past which including working on custom xslt templates, add css and .js scripts on the list view page and working with JSlink to override the rendering of list view web parts.┬áThere was always a challenge that if you have multiple list views …

Continue reading ‘SharePoint Online: Format list columns in modern UI’ »

SharePoint online create sub site using PowerShell

Creating a subsite is quite an easy job from a SharePoint site, and if you are going to create a SharePoint site using Powershell then it will be time taking option and require more technical skills. I would not suggest you to use Powershell script for creating one to two sub sites but if you …

Continue reading ‘SharePoint online create sub site using PowerShell’ »

SharePoint unsupported file types

I worked on older versions of SharePoint where we can upload different file types which were not supported in SharePoint online. Normally user face this issue during migrations from older version. Restricted Characters in file/folder names Below is the list characters which you can not used in file name or folder name in SharePoint Online …

Continue reading ‘SharePoint unsupported file types’ »