Category: 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…
-
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…
-
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…
-
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…