Reference: http://www.howtogeek.com/tips/how-to-extract-zip-files-using-powershell/
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
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
SharePoint Web Service
Microsoft SharePoint offers a web service to query and use to simplify jobs that typically you’d have to need a connection to active directory. Some Basic URLs: http://(Your SharePoint URL)/_vti_bin/UserProfileService.asmx http://(Your SharePoint URL)/_vti_bin/Lists.asmx http://(Your SharePoint URL)/_vti_bin/UserGroup.asmx From within http://(Your SharePoint URL)/_vti_bin/UserProfileService.asmx you can pull these details UserProfile_GUID, AccountName, FirstName, LastName,…
Remove Last N Characters From Column
Recently in a project to list all the plugins in a WordPress site with their versions I had accidently added .0 on to various rows in error. This script was very helpful to correct this error Reference: http://stackoverflow.com/questions/10470471/delete-last-n-characters-from-field-in-a-sql-server-database
Version Delimiter
Reference: Laurence @ http://stackoverflow.com/questions/13315756/how-to-compare-sql-strings-that-hold-version-numbers-like-net-system-version-cl
Code
Read more
Ubuntu – WordPress Install
These steps are based on Ubuntu 14.10 Server 64-bit but can be applied to virtually any Debian based UNIX distribution.
MSSQL Server Information
If you have ever started a new job and we told to “Dig into the database and learn” these scripts likely have come to mind whether or not you knew/know them. References & Credit: http://www.pinaldave.com/ / http://blog.sqlauthority.com/ https://www.simple-talk.com/sql/database-administration/exploring-your-sql-server-databases-with-t-sql/
MSSQL Table Backup Script
This is a quick way to backup table structure and data, this will go out to the system table and query all tables then provide a script to recreate the tables. This is a bit of a hack but works to backup all the rows in your tables. Run the…
Excel Rand
Great if you are creating random passwords, more examples at the reference link below. Reference: http://excel.tips.net/T003872_Generating_Random_Strings_of_Characters.html