All posts in SQL

Building a SharePoint 2019 MinRole Environment in Microsoft Azure – Deploy SQL Server

Once the domain controller is configured and active directory for the farm is created it is time to deploy SQL Server.  Because this will be an “on-prem” farm I will not be utilizing an Azure SQL Database but instead will deploy an actual SQL Server VM.  This is made pretty straight forward as Azure provides a template for this.

This is a multi-part series.  You can see what is coming and review other posts in the series by clicking one of the following links:

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

Business Connectivity Services – It’s Not Dead… Yet

I had a great time recently presenting at CalSpoug’s SharePoint Saturday.  The first session I presented was on SharePoint Business Connectivity Service.  I have done this session quite a few times and I always have at least one attendee state they have never heard of BCS before.  This session was no different.  One of the things I cover is the importance of BCS in different environments.  Many will argue it is an old, unnecessary system.  I do not necessarily disagree with this.  However, I argue it isn’t dead yet.  If you are working with simple data in a SQL Database or even more complex but well-organized data in a database the ease of use within BCS is quickly seen.  In 5-10 minutes you can connect to your data and present it within SharePoint utilizing built-in forms (no custom form development).  Users will be able to read and update the data immediately (assuming permissions are configured already).  There’s more to it than just this and you can take a look at my slide deck to see.

Having said that, I do believe that I see an end to BCS.  PowerApps and Flows make accessing data just as easy and more configurable through the many, many connectors available.  As these connectors mature and the tools grow, the use cases for BCS will slowly disappear.  However, we aren’t there yet.  BCS is still there and still very easy to use.


Take a look at my slide deck and if you have questions, please reach out.


Thanks for reading!

Prepare an Azure Database for SharePoint Online BCS Connection

While working on the demos for a resent presentation I wanted to research some steps on how to prepare an Azure database for Sharepoint Online BCS connection with SharePoint Online.  I found that there was no complete answer in one place so decided to make one… hence this post.  This post assumes you already have an Azure account and necessary rights to configure it.  It also assumes you do not have any DB’s in your Azure environment.  Also note, adding Azure DBs to your environment is not a free service and you will have costs added to your monthly invoice.

Read more