Return to Snippet

Revision: 38288
at June 16, 2011 06:37 by michanne


Updated Code
#Build SQLCMD line for all files in the directory.

dir tables|foreach{$a = $_.Name;"r: Tables\$a"}>201106_Deploy.sql

#Generate random passwords
-join ([Char[]]'abcdefgABCDEFG0123456&%$' | Get-Random -count 20)

#Generate a range of letters base on the ascii code (e.g. A: B:...)
65..90 | Foreach-Object { "$([char]$_):" }

<#Reading Text Files Fast - returns String#>

$a = [System.IO.File]::ReadAllText("$path\wkspace.csv")

<#Reading Text Files fast - returns Array
Measure-command returns time to execute metadata#>

measure-command{[System.IO.File]::ReadAllText("$path\wkspace.csv")}

Revision: 38287
at December 30, 2010 05:01 by michanne


Updated Code
<#Reading Text Files Fast - returns String#>

$a = [System.IO.File]::ReadAllText("$path\wkspace.csv")

<#Reading Text Files fast - returns Array
Measure-command returns time to execute metadata#>

measure-command{[System.IO.File]::ReadAllText("$path\wkspace.csv")}

Revision: 38286
at December 30, 2010 04:55 by michanne


Initial Code
<#Reading Text Files as One Chunk#>
$a = [System.IO.File]::ReadAllText("$path\wkspace.csv")

Initial URL


Initial Description
Short Random lines of code mostly from Powershell.com

Initial Title
Powershell snips

Initial Tags


Initial Language
Windows PowerShell