All posts in SharePoint

Deploying a SharePoint 2019 Development Environment – Preparing Servers for SharePoint 2019

Now that the SQL Server and AD are configured for the farm, let’s go about preparing servers for SharePoint 2019.  There are just a few steps we want to do to ensure the servers are set up for our usage.  With SharePoint 2016 there was the concept of minrole servers.  These being servers that have a specific use.  Whether it be search, web front end, distributed cache, etc, you can minimize the responsibilities of each server to make the farm more efficient.  Because this particular configuration is for a high-end desktop\laptop I will be able to deploy a type of minrole server (we’ll cover that in the next post).  I will build out a full minrole farm in a future post using Microsoft Azure.  In this series, we will deploy an App and a Web server.  This post will assume you have created Windows Server 2016 VMs already.

If you are interested in checking out the other items in this series click on the links below:

Read more

Deploying a SharePoint 2019 Development Environment – Install and Configure SQL Server 2017 for SharePoint 2019

Before you can do anything with SharePoint 2019 you have to install SQL Server.  You have a couple of options available as both SQL Server 2016 and 2017 can be used.  I want to go with SQL Server 2017 (all the latest features right?).  So in this post I will be demonstrating how to install and configure SQL Server 2017 for SharePoint 2019.  If you are wondering why you should bother with SharePoint 2019 at all, review my previous post to review a lot of the features you gain and others you lose.  This series doesn’t cover the AD and server configuration.  There are a couple of posts I did when building out SharePoint 2013 that can assist with this.

If you are interested in checking out the other items in this series click on the links below:

Read more

Deploying a SharePoint 2019 Development Environment – Overview

Now that SharePoint 2019 is out and has been for a while I thought it wouldn’t hurt to update my series for creating a SharePoint development environment.  This series will focus on installing all the components you need for building out a multi-server\tiered environment to build your amazing solutions within.  This first post is going to focus on SharePoint 2019 as a whole.  What’s needed, what’s changed and the options you have for your environment.

If you are interested in checking out the other items in this series click on the links below:

Read more

Inserting Values into Multi-Value SharePoint On-Prem Choice Fields with Microsoft Flow

So one would think this is a no brainer as you can now read and update multi-value fields in SharePoint Online.  In August of 2018, Microsoft announced that multi-value choice fields can now be read from and updated (see this link).  What wasn’t clear is that it doesn’t allow you to do this with SharePoint On-Prem environments via the data gateway.  I have received confirmation from Microsoft that this is, in fact, a limitation for SharePoint 2013 and 2016 on-prem environments, but shouldn’t be for SharePoint 2019.  I haven’t yet tested this claim but will update if the information is untrue.  So in this post, I will be inserting values in multi-value SharePoint on-prem choice fields with Microsoft Flow.  I would like to send a thank you to Rob Windsor who got me started on the path to determine the solution.

Read more

Terminate SharePoint 2013 Workflows with PowerShell

Let’s admit it.  Sometimes things just go wrong and you need an easy or straight forward way of cleaning it up and starting over again.  An example of this happened to me the other day where I had a bad workflow that went unnoticed and started suspending.  By the time it was noticed there were about 50+ suspended workflows (it was an active list).  So after stopping the workflow I started working through cleaning it up and thought there has to be a way to terminate SharePoint 2013 workflows with PowerShell.  Turns out I could do it.  Here’s how:

Read more