We are getting approximately 50-100 lower environments SQL Servers newly build.
We are assigned some basic task of SQL DBA which includes one as patching SQL Servers.
How can this be achieved, specially when we have servers, where only Windows authentication can be used whose password needs to be generated every 24 hours. That makes this look complex or may be something I am expecting too.
Please share your inputs how can we achieve this either via powershell, cmd or any best known approach?
Edit: These boxes are all lower env like DEV/SAT/QA. Some of them have log shipping configured but that too for side reporting , even though not that critical. These are not 365*7 and are generally used during the business EST hours.
Also, we have multiple logins each assigned to a DBA who has sys admin rights on these boxes but that login needs to have a password generated which expires every 24 hours.