I know there are a plethora of commercial solutions, that Google finds easily. I am looking for solutions we can manage in house.
I am looking for other approaches to consider as well. After extensive searching the only other approach I can even imagine is a SQL job, that runs on server restart (server patching occurs regularly generally with restart) that would go look in a shared folder for the most current CU and apply it if not installed. But I don't find any mention of solutions other the those above.
Are there any methods for automating SQL CU patching, that I have not found examples of?
If SQL job patching is viable, are there any examples?