Author Archives: Greg

DOS to Linux line endings in VIM

Switching between Windows and Linux machines every day, you’ll undoubtedly end up with files in the Linux system with DOS line endings. You can easily change the line endings in the editor VIM using the following commands: :w ++ff=dos :w … Continue reading

Posted in Bash, Linux | Leave a comment

PowerShell: Extract Files from Zip Archive

Here’s a quick PowerShell snippet to extract files from a .zip archive: Add-Type -Assembly System.IO.Compression.FileSystem   $PathToZipFile = "C:\temp\myarchive.zip" $ExtractPattern = "*.log" $ExtractDirectory = "C:\temp\extracted"   New-Item -ItemType Directory -Path $ExtractDirectory -Force | Out-Null   $ZipFile = [IO.Compression.ZipFile]::OpenRead($PathToZipFile) $ZipFile.Entries | … Continue reading

Posted in PowerShell | Leave a comment

T-SQL: Find Out Who Has Locks In Your Databases

Here are a couple of ways to see who is locking up your SQL Server database. First, the undocumented system stored procedure sp_who2 gives you a few more columns than the documented sp_who. And second, this custom query gives a … Continue reading

Posted in T-SQL | Leave a comment

Azure PowerShell: Copy All Files in Blob Storage to Local Directory

Here’s a Azure PowerShell script that downloads all blobs in a storage container to your local disk:   $storageAccountName = "mysuperstorage" $containerName = ‘my-blobs’ $destinationFolder = ‘C:\temp\my-blobs’   New-Item -ItemType Directory -Force -Path $destinationFolder   Login-AzureRmAccount   $storageAccountContext = (Get-AzureRmStorageAccount … Continue reading

Posted in Azure, PowerShell | Leave a comment

PowerShell: Read Secure String and Convert Back to Plain Text

Here’s a quick way to read in a secure string and then convert it back to plain text: $SecureString = Read-Host -Prompt "What is the secret?" -AsSecureString $ClearTextString = [Runtime.InteropServices.Marshal]::PtrToStringAuto([Runtime.InteropServices.Marshal]::SecureStringToBSTR($SecureString)) Also, take a look at the ConvertTo-SecureString and ConvertFrom-SecureString functions … Continue reading

Posted in PowerShell | Leave a comment

PowerShell: Generate a Pseudo-Random String

Here’s a quick way to generate a pseudo-random string with PowerShell: $Length = 20 $AllowedCharacters = "abcdefghijklmnopqrstuvwxyz0123456789".ToCharArray() $MyRandomString = -join (Get-Random -Count $Length -InputObject $AllowedCharacters) Hope this helps!

Posted in PowerShell | Leave a comment