This area of the site is dedicated to code snippets for quick and easy reference
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
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, PreferredName, WorkPhone, Office, Department, Title,…
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
Reference: Laurence @ http://stackoverflow.com/questions/13315756/how-to-compare-sql-strings-that-hold-version-numbers-like-net-system-version-cl
These steps are based on Ubuntu 14.10 Server 64-bit but can be applied to virtually any Debian based UNIX distribution.
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/
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 query and it will generate…
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
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