Once you have this module downloaded and installed, it's time to get started. To test a SQL database connection, you'll need at least four pieces of information: the user name password, database name ...

To check if a server has a TPM chip, use the TPM Management Console (tpm.msc), explore Device Manager under Security devices, or run the “get-tpm” command in PowerShell.

To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages. I am going to be focusing on the SQL Server 2012 packages in this article.