Query Conversion Tool Between Oracle And SQL Server

You can use a free tool from Oracle SQL Developer under>>Tools>>Migration>>Translation Scratch Editor

(You may need to register for a free account first to download the software).

Copy Files to Multipe Locations with Robocopy

1. Prepare a destination list with one item each line and save it to the same location as the .bat file;
2.Save the following file as bat file to c:\jobs;

for /f "usebackq tokens=*" %%T in ("FolderList.txt") do (
robocopy c:\temp\myfiles_src\ \\mydestination\%%T\myfolder\ /s /LOG+:C:\jobs\log\%date:~-4,4%%date:~-10,2%%date:~-7,2%_log.txt 

Execute this bat file manually or through a scheduled job.

Schedule a Job To Run SSIS Package to Delete Old Files with Robocopy

Step 1: Create a bat file (saved as TheDeleteFile.bat from notepad in this example)  in the following format (use your own file paths)

IF NOT EXIST \\myShare\SQLData\empty mkdir \\myShare\SQLBackups\empty
Robocopy \\myShare\SQLData\backups \\myShare\SQLData\empty /e /MOVE /create /MINAGE:15 /LOG+:C:\jobfiles\log\%date:~-4,4%%date:~-10,2%%date:~-7,2%_log.txt
rmdir \\myShare\SQLData\empty /s /q


Any files in the  \\myShare\SQLData\backups folder that are 15 days old will be deleted. You can change the number 15 to the number you desire.


Step 2:  Design an SSIS Package with  Execute Process Task component:

The major Process Properties:
RequiredFullFileName: True
Executable: C:\myjobfile\TheDeleteFile.bat
Arguments: ..\bat
WorkingDirectory: C:\myjobfile


Step 3: Set up a job from SSMS to run the SQL Server Intergration Package designed from above step and schedule a time to run this job.







Replace Laptop’s Hard Driver with Intel SSD Driver By Using Intel’s Data Migration Software

It is very easy to upgrade a laptop’s hard driver with Intel SSD with Intel® Data Migration Software.

I used one 160 GB Intel SSD drive to replace a 500 GB HD with 120 GB data on it from ASUS X53E Windows 7 Home Premium.

The cloning mode is manual to control the destination partition size and the other options you can leave it as default to proceed.
It takes a while to finish cloning the 120GB driver through a USB connection. After the cloning, I simply swap the driver with the SSD
and the machine is ready to run.
Download link for the software and manual:

How to Show File Extension in Window 2008 Server and Windows 7

If you open a folder from a Window 2008 Server, you cannot see your files extension any more.
There is a setting you can change to see the extension again.
Follow these steps:

In Window Explore
>>Click on Organize(Up-Left corner)
>> Folderand search options
>>Under View tab
>>Uncheck the checkbox for: Hide extensions for known file types

Go back to your folder and you will see your files with extensions!

Remove Write-Protect (Write Protection) from Jump Drive (Reformat)

My wife’s MP3 jump drive has some files which cannot be removed due to the write-protect of the drive. After messing around for a while, I decide to reformat the drive after making a copy of all files to my computer hard drive.

Go to command line and format the drive (find the drive letter of the drive. In my case, it looks like:

C:\>format g: /x

Got a full formatted drive back.  Then copy some useful files back to the jump drive. Done.

How to access Cmd.exe in Windows 7?

There are some changes compared with what get to the command prompt in XP. I read a summary listed 5 ways to access the Cmd.exe in Windows 7 from book  Windows 7 Inside Out Appedex B: (The command prompt works identically in all editions of Windows 7)

To get to the command prompt, run Cmd.exe, which you can do in any of the following ways:

  • Type cmd in the Start menu search box, and click the Cmd shortcut when it appears, under Programs, at the top of the menu.

  • Press Windows logo key+R, and type cmd in the Open box.

  • Choose Start, All Programs, Accessories, Command Prompt.

  • Double-click the Cmd icon in your %SystemRoot%\System32 folder.

  • Double-click any shortcut for Cmd.exe.

jQuery Samples from Scott Mitchell at 4Guysfromrolla

Here again Scott gave a good write up about how to use jQuery to creat e a filtering user interface in a webform:
It seems he skips the C# code on purpose. 
I converted it to C# and put it somewhere in my Space. You may find it here if you give the full credit to Scott:

How to install ISO file without burning CD/DVD first?

It is holiday break at home and I have time to install some software I am interested to play with. I don’t want to burn all my MSDN software to discs so I search for a solution that is free and easy to use. I came to this product: Virtual Clone Drive, a free program from Slysoft.
 I am waiting for the ISO download now and I’ll post back to report how I feel about it.
I have installed VS 2008 in iso format with this Virtual Clone Drive by simply clicking on the iso file and it worked pretty well.

A backup solution

I have tried different backup solutions but  I like the one from CrashPlan (http://www11.crashplan.com/consumer/features.html).
The free version for home use works pretty good and it helps a lot for us as IT helpers in various situations.
If you want more powerful feature of the software, you can always go with the commecial licence with the pro version (server/online).
Give it a try. Go CrashPlan.