Most of the articles I’ve written about SQL Server with Windows PowerShell have been using Windows Authentication. And while it is highly recommended to use Windows authentication to connect to SQL Server, the reality is that the IT infrastructures we have don’t run on Microsoft Windows.

Here’s an article I wrote on how to use Windows PowerShell to connect to SQL Server via mixed mode authentication