Skip to main content

VMware Virtualization Software

I just created this post to commend the awesomeness of VMware (VMs) as a virtualization solution. I now have 3 VMs setup to isolate test environments for various applications. Back in the mainframe days, this was accomplished through a series of complicated Test & Pilot systems. However, with VMs, setup is quick and there are standard wizards to assist with more complicated tasks. I was able to increase my hard drive from 10GB to 40GB without any painful MSDOS commands using the wizard.

Which brings me to the objective of this post; I have installed the latest and greatest Visual Studio 2010 and will be posting some tips and tricks for integration with the AS400 using managed providers. Coming soon….

Quick Tip: MSDOS

Sometimes we can forget how useful DOS commands can be for managing files and batch jobs. Here’s a quick tip on appending file names:

*Run the following commands in DOS. Make sure to turn the Y?N response indicator to NO!

SELECT FILE_NAME, 'copy ' + FILE_NAME + ' \\server\DATA\Files\filename2011\' + '2011_' + REPLACE(SUBSTRING(FILE_NAME, CHARINDEX('filename2011\', FILE_NAME , 0), LEN(FILE_NAME)), 'filename2011\', '') + ' /Y'

FROM dbo.FILE_NAME_TABLE

WHERE FILE_NAME LIKE '%filename2011%'


If you're feeling brave, create a regular expression to accomplish the above tasks. Fun stuff!

Use at your own risk.


SSH

Comments

RapidSSL said…
This is a great tip, it’s like a giant undo button for when, that’s right WHEN you screw up your code. And I know I’ve certainly screwed up more times than I care to recall. But there is great sense in this tip. As then if you find a bug, and you need to trace back when the bug originated, if you use source control, you’ll be able to get a snapshot of the code at any given time. It also makes building projects a whole lot easier too!
June 3, 2011 at 5:01 AM
Post a Comment