Content

How to Batch Rename File Extensions

So how do you rename multiple file extensions at once? If you have a directory full of files that need to be changed from .PNG to .JPG, it’s going to take forever to do this using the method above. Luckily, there are a couple of different ways we can change the file extension for multiple files at once. Command Line For those of you who are familiar with the command line, there is a very easy command you can use to perform very simple file renaming tasks. There are two…

0 comments

How to copy and paste between your computer and VirtualBox

1- Install additional software After you install VirtualBox and a virtual machine, you want to Copy & Paste between your computer and the virtual machine, you need to install an additional piece of software, which is ” Guest Additions“.On the  VirtualBox window, enter the  Devices/Insert Guest Additions CD Image..function to insert a virtual  CD disc to install this software. After finishing installation, restart your virtual machine  2- Shared Clipboard + Drag & Drop Shut down your virtual machine and go back to the  VirtualBox Manager ​​​​​​​screen. On “General -> Advanced” Tab, select: Shared Clipboard: Bidirectional Drag & Drop: Bidirectional With the above choice, you can copy the…

0 comments

VirtualBox Keyboard Shortcuts

VirtualBox Manager (41 shortcuts) Ctrl + ↑   Shift + A Cloud Profile Manager: Add Profile… Ctrl + ↑   Shift + A Media Manager: Add… Ctrl + A Add machine… Ctrl + ↑   Shift + D Log Viewer: Bookmark Ctrl + ↑   Shift + C Snapshot Pane: Clone… Ctrl + O Clone… Ctrl + P Cloud Profile Manager… F1 Help contents Ctrl + ↑   Shift + C Media Manager: Copy… Ctrl + ↑   Shift + C Network Manager: Create… Ctrl + ↑   Shift + D Snapshot Pane: Delete… Ctrl + Q Exit Ctrl + E Export Appliance… Ctrl + ↑   Shift + T Log Viewer: Filter Ctrl + ↑   Shift + F Log Viewer: Find Ctrl + H Host Network Manager… Ctrl + I Import Appliance… Ctrl + ↑   Shift + I Cloud Profile Manager: Import Profiles… Ctrl + ↑   Shift + M Media Manager: Move… Ctrl + N New machine… Ctrl + ↑   Shift + P Log Viewer: Options Ctrl + G Preferences… Ctrl + ↑   Shift + P Cloud Profile Manager: Profile…

0 comments

Robocopy: Command-line Usage Examples and Switches

RoboCopy (Robust File Copy) is a command-line file copying tool in Windows. It is designed for reliable copying or mirroring of directories anywhere the computer has access, including local drives, removable drives, Local Area Network, remote servers, and in the process ensures that all file properties and permissions stay intact Mirror Sample Copy: Robocopy “\fs1\c$\Docuware Web Baskets” “E:\DWStorage2\WebTrays” /MIR /FFT /Z /XA:H /W:5 Robocopy Syntax and Examples RoboCopy Syntax: robocopy source destination [file [file] … ] [parameters] source: specifies source folder. You can use drive:\path or \\server\share\path here. destination: specifies…

How to Optimize iPhone, iPad and iPod Performance

1. Close Apps Running in the Background On an iOS 10/9/8 device, when you tap the home button to leave an app, you do not “close” that app. In fact, all apps continue to run in the background, and certain apps (social media, apps with “push” notifications, streaming music apps) take up a good chunk of battery when they are running. If you close them when they’re not in use, you could save more battery and RAM to make sure other apps run smoothly. To close them: Double click Home…

Update consecutive numbering with UPDATE statement – MSSQL

I want to update a table with consecutive numbering starting at 1. The update has a where clause so only results that meet the clause will be renumbered. Can I accomplish this efficiently without using a temp table?

What is – DML, DDL, DCL and TCL – Introduction

DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements DDL DDL is abbreviation of Data Definition Language. It is used to create and modify the structure of database objects in database. Examples: CREATE, ALTER, DROP statements DCL DCL is abbreviation of Data Control Language. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. Examples: GRANT, REVOKE statements TCL TCL is abbreviation…

The feed does not have subscriptions by email enabled – FeedBurner

If you see the FeedBurner error message above, this means that you need to enable the subscription by email option in your FeedBurner account settings. It could also mean that you have not obtained the correct FeedBurner ID. How to fix: –  Login at http://feedburner.google.com/ and select your feed. – Go to the “Publicize” tab. – Open the “Email Subscriptions” section on the left. – Make sure that “Email Subscriptions” are enabled Image:

Oracle – Create Table by Select Statement

–WITH data –without data — For example, create a table named EMPLOYEE3 that includes all — of the column definitions from EMPLOYEE where the DEPTNO = D11.

Find Duplicate Values with SQL Script

Let’s assume that data has been entered in a table and now you want to find if a table column have duplicated values. Here is an SQL script to join data from one table for comparison purpose. The table must have a primary key column (unique column) and the second column for comparison. Here is a sample script: Details: – DWDOCID is the primary key column – AIXFlag, is just a fixed value (optional) – SAMPLEEN is the table name – CUSTOMER_NUMBER is the column where I am searching for…