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
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
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
Excel – Find Comma Replace With LineBreak
Selected the range of cells you need to replace. Go to Home > Find & Select > Replace or Ctrl + H Find what: , Replace with: CTRL + SHIFT + J Click Replace All Somehow CTRL + SHIFT + J is registered as a linebreak. Reference: http://stackoverflow.com/questions/14856501/substitute-a-comma-with-a-break-link-in-a-cell