Command Prompt: searching port status and killing a process

Today, while working with Glassfish server, I encounted a weird issue that I restarted Glassfish server but Glassfish failed to start and the most annoying thing was, I found nothing in it's logs. Tried to restart Glassfish from windows service several time but all in vain.
Then I tried to check all the ports used in Glassfish. Ports used by Glassfish can be checked from domain.xml file. Search "http-listner" and make a list of ports.

VMware: Prepare list of VMs with snapshots using PowerShell

VMware snapshots plays important role for VM backup. It is recommended to remove old snapshots as they consume space and may create problems if somebody revert the VM with old snapshot. If you have handsome amount of Virtual Machines, then it will be difficult and time consuming for you to manage those snapshots manually. 

Calculating MySQL Database size.

So Guys, how do you calculate the size of your databases on db server using a simple & single query..
.
.
.
Well this thing is easily achievable by a simple query. For this you need to query information_schema, which will result you the database size and other information.

   SELECT table_schema "DB Name", ROUND(SUM(data_length + index_length) / 1024 / 1024 / 1024, 1) "DB Size in GB" 
   FROM   information_schema.tables GROUP  BY table_schema;

:)