Ok, this has nothing to do with enterprise or business for that matter, but this bugged me and took me too long to find information on so hopefully this helps someone trying to do the same thing. I have a home server currently running Windows Server 2016 that runs my PLEX media server as well as a Minecraft server for a few friends and I. I decided that since I was barely using any resources on said server, I might as well put a little more stress on it!
So shortly after starting my current roll, my first task was automation of patching. I decided to accomplish this with System Center Configuration Manager. My work gave me a single server and a SQL cluster we used for several other applications. I did the obvious thing and tried to utilize the SQL cluster for the SCCM SQL requirement. For my first attempt at installing on the SQL cluster, I let SCCM create it’s own databases (DB’s).
The infrastructure I inherited (You’ll see most of my posts start like this for awhile unfortunately.) consisted of 3 data centers, each with it’s own WSUS running the databases on the local servers with GPO’s pointing either to each local WSUS or one in the other data centers. Here’s a rough diagram to better explain it:
Obviously, this wasn’t ideal and my predecessor had even let the servers slip into disrepair since he was using a third party patching tool.