Handy VBScript to Remove the WhiteSpaces from All File Names in a Folder

Here is a super simple VBScript that will remove any white spaces from filenames in a folder. There’s no need to specify the folder, just copy it to the folder you need and double click to run it. Of course you’ll have to copy the lines of code below into a notepad file and save it…

T-SQL to Enforce Proper Case Capitalization

This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make…