Cacher is the code snippet organizer for pro developers

$strConnectionString = "Password=FaY5FEC5;Persist Security Info=True;User ID=OPWDataWriter;Initial Catalog=OPWBI;Data Source=opwsql03\sp2013tabular";
$conn = New-Object System.Data.SqlClient.SqlConnection
$conn.ConnectionString = $strConnectionString
$conn.open()
$cmd = New-Object System.Data.SqlClient.SqlCommand
$cmd.connection = $conn
$d = Get-Date
$cmd.commandtext = "INSERT INTO Automated_Process_Tracker (StartTime,EndTime,Process,Status,Note) VALUES('{0}','{1}','{2}','{3}','{4}')" -f $d,$d,"Test","TestAgain","TestLast"
$cmd.executenonquery()
$conn.close()