גרי רשף

param(  [parameter(Mandatory=$True)] 

        [string] $SqlServer="myserver.database.windows.net", 

        [parameter(Mandatory=$True)] 

        [string] $Database="MyDatabse", 

        [parameter(Mandatory=$True)] 

        [string] $SqlCredentialAsset ="MyCredential"

    ) 

$SqlCredential = Get-AutomationPSCredential -Name $SqlCredentialAsset 

if ($SqlCredential -eq $null) 

{ 

    throw "Could not retrieve '$SqlCredentialAsset' credential asset. Check that you created this first in the Automation service." 

}   

# Get the username and password from the SQL Credential 

$SqlUsername = $SqlCredential.UserName 

$SqlPass = $SqlCredential.GetNetworkCredential().Password 

# Define the connection to the SQL Database 

$Conn = New-Object System.Data.SqlClient.SqlConnection("Server=tcp:$SqlServer;Database=$Database;User ID=$SqlUsername;Password=$SqlPass;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;") 

# Open the SQL connection 

$Conn.Open() 

# Define the SQL command to run. In this case we are getting the number of rows in the table 

$Cmd=new-object system.Data.SqlClient.SqlCommand("Exec MyProc;", $Conn)

$Cmd.CommandTimeout=0 

# Execute the SQL command 

$Ds=New-Object system.Data.DataSet 

$Da=New-Object system.Data.SqlClient.SqlDataAdapter($Cmd) 

[void]$Da.fill($Ds) 

# Output the count 

$Ds.Tables.Column1 

# Close the SQL connection 

$Conn.Close()