Avoid Plain Text SQL Server Password Inside PowerShell Scripts

This is a Part II from our last video, and also a standalone blog. Within the video we used PowerShell to connect to another SQL Server but we used a plain text password in the PowerShell script. Obviously this is bad, as we know it. Therefore this is a follow-up to that video explaining how you can avoid doing that by adding a layer of abstraction to the User and Password experience.