To install the 2014 PowerShell tools, the script below will help make it a bit easier. First all downloads are referenced from this URL (specific for SQL 2014) http://www.microsoft.com/en-ca/download/details.aspx?id=42295 I use Windows 64-Bit so if you use 32-Bit make sure you update your links Reference: http://www.jbmurphy.com/2014/01/16/quickly-install-the-sql-powershell-toolls-on-your-local-machine/
Category: PowerShell
PowerShell Set DNS Settings
This only works on Windows 8, 8.1, 10 as the Cmdlets Set-DnsClientServerAddress Get-DnsClientServerAddress are introduced in Windows 8. First get the interface name(s) you want to modify Change the code below to the interface you wish to change
WordPress – List All Plugins
Place the following code on a file ex. ListAllPlugins.php and then navigate to http://yourdomain.com/ListAllPlugins.php This is a PowerShell script to automate some of the information
PowerShell Download Latest WordPress Plugin
This script will call out to a defined URL to check the version of a plugin and download the update if needed. To use:
PowerShell Special Folders
Named Special Folders: Desktop Programs Personal MyDocuments Favorites Startup Recent SendTo StartMenu MyMusic DesktopDirectory Templates ApplicationData LocalApplicationData InternetCache Cookies History CommonApplicationData System ProgramFiles MyPictures CommonProgramFiles
PowerShell Download File and Extract File
Grabbing code from Powershell Download Script and Powershell Extract Zip Files this script will download with the option of extracting the zip file. In PowerShell if you type the following you will get two examples of how to use the code.
PowerShell Extract Zip Files
Reference: http://www.howtogeek.com/tips/how-to-extract-zip-files-using-powershell/
Powershell Download Script
Pass variables to the script Manually type values in the script execution References: http://windowsitpro.com/powershell/prompting-user-input-powershell https://teusje.wordpress.com/2011/02/19/download-file-with-powershell/ http://stackoverflow.com/questions/5592531/how-to-pass-an-argument-to-a-powershell-script
PowerShell – CSV Columns and Character Count
Reference: http://stackoverflow.com/questions/8685034/error-importing-5-gig-file-into-table