Month: May 2012

Changing the name of a SQL Server Machine

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…

Read More »

Microsoft Excel – Turn a “1” into “001”

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. Format–>Cells, Number tab, Choose Custom and type 000 into the short box at the right. In Excel 2007: From the Home tab, go to Cells, select Format, then Format Cells. Go to the Number tab,…

Read More »

Useful DOS Commands

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. How to delete files equal to zero bytes in size. Delete…

Read More »

How to use multiple blockquotes in WordPress using CSS

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. In this example, where the following…

Read More »

Delete Files and Subfolders from Folder but not that Folder Itself

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. Warning: There are a few things that I discovered while testing this script. Firstly, the CD command, which is part of this script will accept a / character as…

Read More »

How to search and replace text from a very large XML file

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…

Read More »

DOS Batch – Find and Replace all occurrences of a string with another string

A fantastic write-up 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…

Read More »

How to wipe a Blackberry 9530 and unlock it to prep for sale

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. Requirements 9530EastAsia_v5.0.0.1041_P4.2.0.456 Operating System (optional) BlackBerry Swiss Army Knife (“BBSAK”) BlackBerry Reader…

Read More »

Use DOS Batch to show last month date with the date command

Use a DOS script to automate a process where by using the date /T command would return the previous month, rather than the current month. This actually sounds easier than it is. For the desired results, a couple of conditions were considered. Firstly, if in the month of January or one, then the subtracted value of one minus one equals…

Read More »