When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good tip
Open PowerShell ISE and press CTRL + J
You will find a number of snippets that will enable you to write your scripts easily. Johnathan Medd PowerShell MVP has written a good post about snippets on the Hey, Scripting Guy! blog so I will not repeat that but suggest that you go and read that post. It will show you how quickly and easily you will be able to write more complex Powershell scripts as you do not have to learn the syntax but can use the snippets to insert all the code samples you require.
Not only are there default snippets for you to use but you can create your own snippets. However there isn’t a snippet for creating a new snippet so here is the code to do that
$snippet1 = @{ Title = 'New-Snippet' Description = 'Create a New Snippet' Text = @" `$snippet = @{ Title = `'Put Title Here`' Description = `'Description Here`' Text = @`" Code in Here `"@ } New-IseSnippet @snippet "@ } New-IseSnippet @snippet1 –Force
I frequently use the SQL Server SMO Object in my code so I created this snippet
$snippet = @{ Title = 'SMO-Server' Description = 'Creates a SQL Server SMO Object' Text = @" `$srv = New-Object Microsoft.SqlServer.Management.Smo.Server `$Server "@ } New-IseSnippet @snippet
I also use Data Tables a lot so I created a snippet for that too
$snippet = @{ Title = 'New-DataTable' Description = 'Creates a Data Table Object' Text = @" # Create Table Object `$table = New-Object system.Data.DataTable `$TableName # Create Columns `$col1 = New-Object system.Data.DataColumn NAME1,([string]) `$col2 = New-Object system.Data.DataColumn NAME2,([decimal]) #Add the Columns to the table `$table.columns.add(`$col1) `$table.columns.add(`$col2) # Create a new Row `$row = `$table.NewRow() # Add values to new row `$row.Name1 = 'VALUE' `$row.NAME2 = 'VALUE' #Add new row to table `$table.Rows.Add($row) "@ } New-IseSnippet @snippet
Denniver Reining has created a Snippet Manager which you can use to further expand your snippets usage and it is free as well.
If you have further examples of useful snippets please feel free to post them in the comments below
Edit 16/12/2014
I am proud that this article was nominated for the Tribal Awards. Please go and vote for your winners in all the categories
http://www.sqlservercentral.com/articles/Awards/119953/
Personally in the article category I will be voting for
I love this snippet-snippet! Immediately added it to my ISE!
Pingback: (SFTW) SQL Server Links 12/09/14 - John Sansom
Pingback: BPOTW 2014-10-12 | SQL Notes From The Underground
Pingback: Useful PowerShell ISE Snippets « FoxDeploy.com
Pingback: Tribal Awards 2014 Finalists – Simple-Talk
Pingback: Populating My DBA Database for Power Bi with PowerShell – Databases | SQL DBA with A Beard
Pingback: Quickly Creating Test Users in SQL Server with PowerShell using the sqlserver module and dbatools | SQL DBA with A Beard