Powershell sql server invoke sqlcmd

Hi, My name is Jimmy Sam. If you need DBA help, please email to jimmy_sam001@yahoo.com for further discussion. Thanks.

Powershell Version

SQL Server PowerShell (SQLPS)

SQL Server Management Objects (SMO) smo 

.NET (System.Data.SqlClient) sqlclient 

Invoke-SqlCmd invoke_sqlcmd

$PSVersionTable
$PSVersionTable.PSVersion

Get-Module -ListAvailable
Import-Module -Name SQLPS
Import-Module -Name SqlServer

%ProgramFiles%\WindowsPowerShell\Modules\SqlServer

Get-Command -Module SQLPS
Get-Command -Module SQLSERVER

New-Alias sql Invoke-Sqlcmd 

Invoke-SqlCmd -ServerInstance -Database -Query -Username -Password

Invoke-Sqlcmd -Query "SELECT GETDATE() AS TimeOfQuery;" -ServerInstance "MyComputer\MyInstance" -Username $MyLogin -Password $pwd

Reference

msdn Powershell