By combining PowerShell and Windows Forms you can create your own SQL Tools. From the Windows Form you can execute your SQL and PowerShell scripts with just a couple clicks of a mouse. The added bonus is now your scripts are in a central location that is tailored to your needs.   I have created a base form below so you can get started adding you own scripts. If you’re new to PowerShell save the code below as a ps1 file and then run it from the PowerShell.

####################### PowerShell Code ###############################

function CreateForm {

Add-Type -AssemblyName System.Windows.Forms

Add-Type -AssemblyName System.drawing

$form1 = New-Object System.Windows.Forms.Form

$button1 = New-Object System.Windows.Forms.Button

$button2 = New-Object System.Windows.Forms.Button

$checkBox1 = New-Object System.Windows.Forms.CheckBox

$checkBox2 = New-Object System.Windows.Forms.CheckBox

$InitialFormWindowState = New-Object System.Windows.Forms.FormWindowState

#Form Parameter

$form1.Text = “My PowerShell Form”

$form1.Name = “form1?
$form1.DataBindings.DefaultDataSourceUpdateMode =…

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Width = 550

$System_Drawing_Size.Height = 150

$form1.ClientSize = $System_Drawing_Size

#Add…