SharePoint Tidbit – Optimizing SQL for SharePoint on-prem

Hello All, First of all, these steps will be true for both SharePoint 2013 or SharePoint 2016 unless mentioned otherwise, as well the steps will be true for all supported versions of SQL unless stated otherwise. I’m sure you realize this but let it be said SQL is the heart, brain, and body of SharePoint…

0

Setting Access Request for SharePoint 2013/2016

Hey Guys, Took a quick look and figured how to set Access Request for all Site Collections, the script is provided AS-IS and should be considered a sample. While I have some error checking and extra logic in there you will probably want to add your own in there. Add-PSSnapin Microsoft.SharePoint.PowerShell $DefaultEmail = “admin@weaver.ad” Get-SPSite…

0

SharePoint Tidbit – Patching SharePoint 2013

Hello All, First to start, you will have the following steps:  Apply binary to all Servers Run Upgrade-SPContentDatabase Perform PSConfigui.exe on First Server (Pick any server it really doesn’t matter) Perform PSConfig.exe on the remaining servers For the first step it is better if you can stop all SharePoint services on the server as this…

0

Manipulating webparts using PowerShell

Hello All, One of my customers is making some changes to there Sites and part of that is to set the owner in a Contact Details webpart, since it is for several site we went and figured out the PowerShell.  The customer changes the title from ‘Contact Details’ to ‘Site Owner’. I wrote this without…

0

Opening Visio files from SharePoint 2013/2016/SPO

Hello All, Not sure if your aware but Visio files are considered restricted and you are forced to download before it can be opened in the client application (Including Visio viewer).  This of course is very annoying, you could deal with this in these manners SharePoint 2013/2016: 1.Install Office Online Server and connect SharePoint (New-SPWopiBinding)…

0

SPO Tidbit – Change to external users in O365

Hello All, Microsoft is updating the behavior and governance of access by external users in Microsoft Office 365. After 3/23/2018, an external user will see only the content that’s shared with that user or with groups to which that user belongs. External users will no longer see content that’s shared with Everyone, All Authenticated Users, or All Forms…

0

Reminder about SQL Aliases

Hello All, Recently I was working with a customer as they migrated between SQL servers, and was implementing a SQL alias and after sending them instructions to implement via Registry key they saw performance issues when they hit approx. 5,000 concurrent user connections.  The problem was that they missed implementing one of the registry keys…

0

Unable to delete file in SharePoint Online

Hello All, Recently I had a customer contact me with an issue in one of their document libraries, when they tried to delete a group of documents thru the GUI they got the error ‘File not Found’.     As well when they tried to access the documents using CSOM they got an error ‘Exception…

2

SPO Tidbit – Create and use Custom Site Designs

Hello All, Moving forward with the new sites in SharePoint Online, the way we customize that site has been changed as well.  First with Site Themes and now with Site Design which is currently rolling out to First Release tenants.  They are simple to use as they are incorporated into the Site creation menu, users…

0

SharePoint Tidbit – SharePoint Migration Tool

Hello All, As you plan your migration from your on-prem SharePoint farm to SharePoint online, I would like to encourage you to look at the SharePoint Migration Tool being released by Microsoft.  The tool was made generally available 1/9/2018. First we recommend the following hardware for the on-prem tool machine that is performing the migration,…

0