After cloning a Microsoft SQL 2000 Server into a virtual machine and renaming the server, the scheduled Jobs no longer worked. Essentially, the reason is that the jobs were created while using a server with a different server name. The SQL Server will act as if the job originated on a master server, and will not allow changes to that job definition. Microsoft suggests in a KB to rename the server back to the original name, delete the job(s), and rename the server to the new name, however, there is an easier method, use the Query Analyzer....
Continue reading ...

To convert numbers like 1, 10, 100 to 001,010, and 100 within a Microsoft Excel spreadsheet, there are a couople of ways to accomplish this....
Continue reading ...

From time to time a DOS batch ("bat" or "cmd") file needs to be written to perform some task or series of tasks. There are various commands that I seem to consistantly search for on the Internet. Here is a list of some of those useful DOS batch commands....
Continue reading ...

There was a need to use blockquotes for different uses. Warning, Informational, Stop, Go, or as a blockquote. The possibilities are endless. This is possible by giving the blockquote element a class attribute within your (X)HTML or post, and define the class in the style.css file of your theme. This technique was found here....
Continue reading ...

If you would ever want to use a command line delete all the files and folders from within a folder without deleting the folder itself, a batch file can be constructed....
Continue reading ...

There are many 'solutions' that exist that will parse through a text file and other utilities that have specific functions designed to parse through an XML file. After trying several applications only one was capable of effeciently search and replace text within (in this case) an XML file that is over 300 MB in size. The whole process took less than one minute!...
Continue reading ...

A fantastic writeup for a batch file, DOS Batch - Find and Replace, that allows string substitution in a text file. It parses each line of a text file for a particular string and replaces it with another string. For example, to replace all occurrences of "red" in "color.txt" with "blue" and put the output on the screen. The script is called BatchSubstitute.bat....
Continue reading ...

There are several steps to preparing the BlackBerry 9530 phone prior to resale. Remove the old phone number from the phone, factory reset, wipe, unlock, remove the SIM and SD cards. After reviewing many resources, YouTube videos, and finally a couple of interesting utilities, this is all possible....
Continue reading ...