READ WIT ME

List the network available in XenServer using : xe network-list Identify the selected network by it's UUID, then destroy the network using : xe network-destroy uuid=fe0651d4-da09-8fc2-5407-4b707d614a5e List the networks again to confirm.

You want to create a sql to list data group in year (datetime datatype). Example as below : The table is smp.SC03F_TEMP with over 10 million rows. Usually, if there something deals with date we will use to_char function. As an alternative, you can use extract function to extract certain part of the date. In belows example, we extract the year of a column. As we can see the time taken is almost half for 10 million rows. Happy trying. select count(*) from smp.SC03F_TEMP; -- 10,866,921 records select count(*), to_char(A.SC03TARIKH, 'YYYY') from smp.SC03F_TEMP a group by to_char(A.SC03TARIKH, 'YYYY'); -- Time taken 54sec

Open 'Command Prompt' by goto 'Start - Run' and type cmd and press 'Enter' key. Type net use to get list of mapped network. To clear all connection, type net use * /delete and pres 'Enter' It will ask whether to delete or not each mapped connect made from your PC.

Usually uncompressing a tar'ed compressed file requires the use of two utility and pipe '|' through each other. Today, I found an easy way to to that. Traditionally, to extract tar.bz2 , we use  bzip2 -cd files.tar.bz2 | tar xvf -    and so with .gz files the easy way is this way,

Just setup my old Sun Fire 280R server. Then try to identify my HBA card; after do some googling this is the command.

Recently just upgraded my test NexentaStor CE from 3.1.2 to 3.1.3 (r9990). Here are the walkthru of the process upgrade. nmc@nx:/$ setup appliance upgrade Cleanup upgrade caches (note: cleanup is generally not required and can be skipped in most cases; if you say Yes, prepare to wait for software upgrade to complete a bit longer) ?  Yes   <=answer y You are about to upgrade the appliance software. Please be advised that by executing this operation you agree to be bound by the terms of the product license available at http://www.nexenta.com/nexentastor-licenses. This operation may take some time to check with the remote appliance's software repository. Proceed?  Yes <=answer y Checking repository sources. Please wait...

So you've finally succeeded running a windows virtual machine (VM) on your desktop. You play around the vm; copying files, installing & deleting applications and so on. After a while, you found out that your vm is using let say 20gb out of 100gb (which you set during creating the vm) disk but your local machine (host) report that you have used up 50gb. So how can you claim back that extra 30gb in your host ?