More for me than you. I constantly have a need to convert bytes to GB or MB as an expression, yet I constantly forget how to do it. Here is how:
gci -Path 'c:\' -Recurse -File | where{$_.Extension -eq ".bak"} | sort -Property Length -Descending | SELECT Name, @{Name="SizeGB";Expression={$_.Length / 1GB}}
Sql Server Powershell 
Leave a comment