What's your experience to deal with the offboarding account? I am thinking about doing the cleanup after the employee offboarding. Such as check across the multiple SQL instances and remove the offboarding account and the user on the database level.
Since it's across multiple SQL instances, I am considering using the dbatools PowerShell module. But not sure if it's a good way.
Anyone have a good experience to share with me?
Many thanks,
Central Management Server (or Local Server Groups) is another option for multi server administration.
https://docs.microsoft.com/en-us/sql/relational-databases/administer-multiple-servers-using-central-management-servers?view=sql-server-ver15