Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

PowerShell

How to script SharePoint Prerequisite IIS Role

When creating a new SharePoint 2013/2016/2019 server, the IIS web role needs to be installed with certain features enabled.   Below is PowerShell one liner to accomplish that.  Cheers. 

shades_smile

Code

Screenshots

image

Delete ALL One-Time SPTimerJobs

One time SharePoint timer jobs can often get “stuck” and fail to execute.   Clearing them all out manually in Central Admin is tedious.  PowerShell below will remove all “One-time” jobs with a one liner. Cheers.  

shades_smile

PowerShell Code

Screenshot

image

References

Measure Performance – SharePoint Online (o365-speed)

PowerShell offers an excellent way to measure command line execution times with “Measure-Command” and Script Block.   With the example below, we run 10 repetitions to connect to SharePoint online and measure the response time in milliseconds.   Cheers!  

shades_smile

Video

Measure Performance – SharePoint Online (o365-speed) from Jeff Jones on Vimeo.

Source Code

Screenshots

image

References

PWA Refresh – Clone Project Server to Lower Env (DEV)

Cloning a project server environment is not a simple procedure.   Wanted to share notes to help others.   Duplicating the SQL databases is a good start.   However, there are internal issues with duplicate GUID (same number already in use) that can create issues.

To resolve that hurdle I coded PowerShell which generates a new GUID and updates Site Collection (SPSite) via TSQL directly.   https://github.com/spjeff/spadmin/tree/master/SPContentDatabase-Replace-Site-GUIDs

With a fresh new GUID in place we can follow steps in SharePoint Central Admin, PowerShell, and PWA Settings to bring the new PWA database pairs (SharePoint Content + Project Plans) online for customers.   Word DOC included below with step-by-step detail.   Cheers! 

shades_smile

Download Checklist

PWA Refresh Procedure.DOC

Diagram

image

Context Diagram

References

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲