Problem / Solution
PowerShell has many uses for SQL Server DBAs and Developers. There have been several tips written about different aspects and how PowerShell can be used with SQL Server. In this video tip, Tim Smith looks at six useful PowerShell scripts that can be used to simplify day to day tasks.
Key Learning Items
The video covers how to:
- Unzip All Zip Files In A Folder
- Zip All Files In A Folder To A Zip File
- Add Existing Code To Locations or New Projects
- Automatically Rename A Folder With A Date
- Automatically Create A Folder With A Date and Dump Filter Files Into It
- Add Date (And Possibly Text) To All Files By Extension In A Path
Read Companion Tip
Tim consults for FinTek Development and teaches the course Automating ETL on Udemy. He’s worked with technology since high school, helping his school win its first TCEA award and continues to work in automation, data architecture, back-end development, and smart contract architecture. Tim enjoys testing new technologies early in the diffusion of innovation curve and was an early adopter of NoSQL and smart contract development. He has a blog at http://www.fintekdev.com/ and helps contribute to local technical and financial events in Texas.