This month (2021 Nov) Microsoft announced a new on-premise SharePoint, named “SharePoint Server Subscription Edition” is commercially released. I cannot find the licensing terms for it at the moment. However I guess an annual “subscription” fee is required depends on number of users. …

For SP2013 and before, when content database being updated, the SharePoint service need to be stopped to avoid locking the content database. Since SP2016, upgrade of content database will not cause down time. It makes zero downtime patching (ZDP) possible. You can refer to follow 2 articles to understand the…

If you googling for “how to check powershell version” you will not get the most updated and accurate answer. Those websites suggest open the PowerShell command console and run $PSVersionTable to get the version. However, in this way you will not aware PS6/7 is also installed. It is because PowerShell…

Recently we patched our SharePoint 2016 on-premise farm. After patched on all 4 servers in farm and run the Product Configuration Wizard, 1 of server returned error as below: Failed to register SharePoint services. This is not a critical task. These failures won’t affect basic functionality, but some sites or…

Nowadays if we talk about SharePoint, 7 out of 10 discussion is about SharePoint online. Seems not many people understand SharePoint on-premise. Today one of our development environment (a SharePoint 2019 on-premise farm) encountered an error. I would like to log it on blog before everyone forgot how to troubleshoot. …

In last article, we know how a PowerApps developer publish their app. Now the end users can see the published app in PowerApps list. According to MS article here, If you create and share an app that includes data from an on-premises source, the on-premises data gateway itself and certain…

Do you know what is on-premise data gateway? You may refer to Microsoft article here for details or read my short summary. Power Platform, include PowerApps and Power Automate (it was called Flow before), are cloud services provided by Microsoft. …

That’s it. The title said it all. I seriously doubt how many SharePoint administrators have even tried to setup on-premise data gateway in their environment. Giving that the gateway have been released for several years, I should not be the only SP admin come across this problem? The scenario is…

In SP2010, we love the feature to bulk edit a SharePoint list. We can easily change entire column to another value by several clicks. However, in SP online modern view, you cannot bulk edit it. It is a pain when you need to modify 1000+ cells all at once. So…