VIDEO – PowerBI Dashboard in a Day (DIAD) – Exercise 5
Recently I completed Microsoft’s DIAD workshop on PowerBI. Below is a video of Exercise 4 from Microsoft Power BI DIAD.PDF (pages 58-88).
Cheers!
What’s in that patch? Apr 2018
NOTE – PDF format updated to include both SharePoint 2013 and 2016 notes.
Ever wondered what fixes are inside of a given CU? Please see attached PDF with full detail. I wanted a new format for easy reading. Show management and make the business case for why downtime should be taken to apply CUs. Also posted at https://sharepointupdates.com/
If you found this helpful, please leave a comment.
![shades_smile_thumb_thumb_thumb_thumb[2]](https://www.spjeff.com/wp-content/ftp_uploads/Whats-in-that-patch-SharePoint-2013--Oct_A762/shades_smile_thumb_thumb_thumb_thumb2.gif "shades_smile_thumb_thumb_thumb_thumb[2]")
Download
| What’s in that patch – Apr 2018.PDF |
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!
Download Checklist
| PWA Refresh Procedure.DOC |
Diagram
References
- https://github.com/spjeff/spadmin/tree/master/SPContentDatabase-Replace-Site-GUIDs
- https://epmsource.com/2013/05/08/migrating-project-derver-2013-database-between-environments/
- https://docs.microsoft.com/en-us/project/deploy-project-web-app-with-a-new-site-collection-project-server-2013
- https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/mount-spcontentdatabase
- https://docs.microsoft.com/en-us/powershell/module/sharepoint-server/set-spprojectpermissionmode?view=sharepoint-ps
