invoke-sqlcmdBasics.ps1

# credit: https://virtuallysober.com/2018/05/30/connecting-to-microsoft-sql-databases-using-powershell-invoke-sqlcmd/

$ServerInstance = "aardvark"
$SQLUser = "sa"
$SQLPassword = "thedemo"

Import-Module SqlServer

$dbCheck = "
with userDatabaseSet as (
    SELECT
    DB_NAME(db.database_id) dbName
    FROM sys.databases db) 
select dbName from userDatabaseSet
where dbName not in ('master','model','msdb','tempdb')
order by dbName
"

try {
    $dbResult = $null
    $dbResult = Invoke-SqlCmd -Query $dbCheck -ServerInstance $ServerInstance -Username $SQLUser -Password $SQLPassword
    $success = $true
}
catch {
    $success = $false
}
"ServerInstance: $ServerInstance"
"success: $success"
"dbResult:"
$dbResult