Video of 6 Useful PowerShell Scripts to Help SQL Server DBAs and Developers


By:   |   Updated: 2014-12-12   |   Comments (1)   |   Related: More > PowerShell




 






Enter your business email address to
get free SQL Server tips.

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 Tips

Click Here



Last Updated: 2014-12-12


get scripts

next tip button



About the author
MSSQLTips author Tim Smith Tim Smith works as a DBA and developer and also teaches Automating ETL on Udemy.

View all my tips
Related Resources





Comments For This Article




Friday, December 12, 2014 - 2:03:52 PM - Sri Back To Top (35601)

Good video!!



download





Recommended Reading

Setting the PowerShell Execution Policy

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

Using PowerShell to Work with Directories and Files

Bulk Copy Data from Oracle to SQL Server

Execute SQL Server Stored Procedures from PowerShell








get free sql tips
agree to terms


Learn more about SQL Server tools