How to Use PowerShell to Set Secure SA Passwords in Bulk


Introduction

In this article, I will help you how to set secure SA passwords for bulk servers. Sometimes we have many SQL server instances in the company environment, with the count being in the hundreds. For security requirements, you may need to ensure the SA password is different for all of them, while making strong passwords. There will be too many tasks if you do it manually,  so the best practice is to bulk set the SA passwords with a script and store them securely.

My solution is to use PowerShell to generate strong random passwords with the server list