How to Disable SharePoint Designer 2013 using PowerShell?

SharePoint Designer 2013 is a great free tool from Microsoft to customize SharePoint sites and create workflows. Why should we disable SharePoint designer? Well, In some cases site owners and designers may damage SharePoint with this Powerful utility, and I’ve seen SharePoint designers become SharePoint destroyers! So, to prevent irreversible damages to…

Read more

Export SharePoint List Data to SQL Server Table using PowerShell

Requirement: Export SharePoint list data to SQL Server table. For an in-house built business intelligence tool, We had a requirement to export SharePoint list data into an SQL Server table. As directly querying SharePoint content databases is not supported by Microsoft, and it also could cause performance issues to your SharePoint farm…

Read more

Add Site Collection Administrator to All Sites in SharePoint using PowerShell

Site collection administrators have God-like power within a Site Collection in SharePoint 2016. Apart from Primary & Secondary site collection administrators, we can add additional site collection administrator on any SharePoint site collection. How to Add a Site Collection Administrator in SharePoint 2016? To add a Site Collection Administrator follow these steps:…

Read more

Fast Site Creation in SharePoint 2016

Fast Site Creation is a new feature introduced in SharePoint 2016. As the name suggests, Fast site Creation helps to speed up the site collection creation process. Internally, site collections are copied at at SQL Server content database level, instead of calling traditional object model calls. Typically, this helps any large organization…

Read more

How to Restore Previous Document Version in SharePoint 2016 using PowerShell?

Version history feature in SharePoint enables us to track changes and revert to old versions when turned ON. Any changes made in SharePoint Online list item or document, creates new version. There are scenarios you could run into, where you have to roll back to an older version of document. All you…

Read more

Create Site Collections in Bulk from a CSV File using PowerShell in SharePoint 2016

PowerShell cmdlet New-SPSite is used to create new site collections in SharePoint. It takes URL and Owner mandatory parameters with other parameters. Here is an example: Create SharePoint Site Collection Using PowerShell : PowerShell to Create Multiple Site Collections in Bulk from a CSV File: Let’s add some error handling and wrap…

Read more

How to Reload SharePoint Page Every 60 Seconds Automatically with JavaScript?

Requirement: For a monitoring dashboard, got a requirement to reload Intranet SharePoint site’s home page for every five Minutes. Solution: Use this JavaScript placed in a Script editor or content editor web part to refresh a SharePoint page every 60 seconds. Here is how to refresh the current page in SharePoint step…

Read more

How to Create External Lists from SQL Server using BCS in SharePoint 2016?

Business Data Connectivity Services enables SharePoint 2013/2016 and Office 2013/2016 clients to interact with data that doesn’t live in SharePoint.  BCS allows you to integrate external data into SharePoint, External list provides a familiar list like user experience. Let’s see how to create an External List in SharePoint that grabs the data…

Read more

Create Business Data Connectivity Service (BCS) Application in SharePoint 2016

The Business Data Connectivity (BDC or BCS) service application in SharePoint 2016 enables us to connect and manipulate with external line of business data sources such as SQL Server, web services, WCF Service, SOAP, REST Service Connection, XML file connection, oAuth and other proprietary data sources that are accessed by custom .NET…

Read more