Keep Recent Folders Delete Older In DOS

There are often scenarios such as rolling backups or rolling logfiles where I create folders which have the date in the folder name.

HINT: Using the format YYYYMMDD means that an alphabetic search is also chronological!

In most cases I only want to keep a certain number of these folders and delete the older ones. The following script will implement this deletion process.

Continue reading Keep Recent Folders Delete Older In DOS

Format Date in DOS Command Line

For any dos batch files that I run on a regular basis I commonly want to create a folder or a text file with the current date in the file name. I’m a purist and I like my dates formatted as YYYYMMDD so that an alphabetic sort is also chronological.

The following script will place the current date into a variable in the required format.

Continue reading Format Date in DOS Command Line

Tell Me When The DB Is Back

database 2
Creative Commons License photo credit: Tim Morgan
Today at work the development DB went down.
My days of fixing databases are long gone, but the guys that are are not so good at letting everyone know that the database is back up.
I created this windows batch script to let me know.
Continue reading Tell Me When The DB Is Back