$files = Get-ChildItem -Path . -Filter "*.sql"$counter = 5foreach ($file in $files) {$newName = "{0:D2}-$file" -f $counterRename-Item -Path $file.FullName -NewName $newName$counter++} Original sql files in a folder After execution of above script, files are renamed.

Being a DBA many times it happens that we need to execute few queries in SQL Server, the following is one of the way to execute SQL Script in PowerShell. 1. Copy this entire script into a PS file ( say C:\Test\sample.ps1) 2. Please edit you Server,DB, and query details 3. Open power shell window … Continue reading How to execute TSQL using Power shell