SELECT (SqlQuestion) FROM MySqlBased
WHERE Learning = 'Growth';

Monday, January 30, 2012

Size Matters!!! Find out how to RESIZE your Microsoft VHD files




Does Size Matter?
------------------------
I found this great article on resizing a fixed size vhd and was able to modify my vhd so I could install more applications for a project. I made some modifications to the article according to my experience but Jason Faulkner was able to create a pretty nice walkthrough of this process.


How to Resize a Microsoft Virtual Hard Drive (VHD) File
-------------------------------------------------------------------------------
When you create a Microsoft Virtual Hard Drive either through Virtual PC or Virtual Server, you have to specify the maximum size of the file up front. While you can set the VHD to be a fixed or dynamically sized file, the total size the VHD is determined at the time you create it. Over time, however, you may want to increase the total size of the VHD file as requirements for the system change to allow more space for installed programs and data files.


Increasing the Size of the VHD File Steps:
---------------------------------------------------------
1. When opening VHD Resizer the wizard prompts you for the source VHD file to resize.
2. After selecting the source, set a destination VHD to a new file. This new file will be an exact copy of the source, only a larger size.
3. Once selected, set the new size of the destination VHD file. This will be the capacity of the new VHD. Once set, start the resizing process.
4. Depending on the size of the source and destination file, this can take some time.
5. Repeat the process for any additional VHD files.

Resizing the Partition of the VHD Drive:
-------------------------------------------------------
After resizing the VHD file, the extra space is recognized by the respective Windows installation as an unallocated partition. In order to assign this extra space to the system drive, we have to link the new VHD file to an existing VHD file and resize it within the virtual machine.

1. In an existing VHD file, such as the source, link the new VHD file as a second hard disk. This is done through the the properties of the virtual machine.
2. Once you have the new VHD linked as a secondary drive, start the respective virtual machine.
3. Once the virtual machine is up and running open up Computer Management by clicking on the Start tab>Run and type in "compmgmt.msc" When you look at the Disk Management, you can see the additional space is unallocated.
4. In order to resize the system drive on the new VHD file, you use the Windows cmd line.

Command Prompt:
---------------------------
1. open cmd
2. type "diskpart"
3. type "list disk". This will list the Disk available with the respective size.
4. type "select disk=1" (the bigger size). The cmd line will return "Disk 1 is now the selected disk"
5. type "list partition". The cmd line will return the Partition #, Type, Size, and Offset.
6. type "select partition=1". The cmd line will return "Partition 1 is now the selected partition.
7. type "extend". The cmd line will return "DiskPart successfully extended the volume"
8. type "exit". You are done

5. After the extend command of Diskpart has run, the previously unallocated space has been combined with the system drive to form a single larger drive.
6. Once you have resized the new drive, shut down the virtual machine you used to resize the new drive and then remove the new VHD file as the secondary drive.
7. The new VHD file is ready to use as it’s own virtual machine, so create a new VM based on the newly created file.
8. Once created, boot up the new virtual machine.The new VHD file will now have a single drive with the new space available to use as needed.

Software: VHD Resizer Application
Source by Jason Faulkner: How To Resize a MS VHD file

Friday, January 27, 2012

26.2 with Donna 2012 Breast Cancer Marathon


Thank you for visiting my page to help contribute to a great national cause to fight Breast Cancer. I am very humble to be apart of this event for 2012. As an act of service I would like help raise $100 for this event. I personally have not lost a relative to this ailment but I have seen dear friends watch helplessly as they are forced to reason with the inevitable. On Feb 12th 2012 @ 6:30am I plan to give my love and support by completing the 26.2K with Donna Breast Cancer Marathon. Please come out and support all the families and participants as this will be a special and rememberable way to bring in the new year for 2012. If you are interested in donating please click on the pink ribbon icon on the left side on my blog. The donation is secure and can be as little as a $5 dollar Starbucks Latte or as big as filling up for a full tank of gas. Anything is greatly appreciated for this cause! Again, Thank you for your support!

Sincerely,  
Maurice Ben-Oduro

Sites to Visit:
      O  The Donna Foundation
      O  Mayo Clinic



Wednesday, January 25, 2012

Setup/Config of Oracle Server and Toad for Oracle


If you find the need to test in an Oracle Environment this guide may be helpful for a quick ramp up.

Setup Oracle Server:
-----------------------------

1. Go to http://www.oracle.com/technetwork/database/express-edition/downloads/index.html?ssSourceSiteId=ocomen

2. Accept license

3. (Must have an account with Oracle, which is free) Download "Oracle Database Express Edition 11g
Release 2 for Windows x32"

4. Unzip "OracleXEE112_Win32.zip" the download and run the DISK1/setup.exe

5. Follow the Wizard. If you get the Error Message below follow the Solution below.
____________________________________
Error:
The installer is unable to instantiate the file
C:\Users\moduro\AppData\Local\Temp\{50B364D8-9C83-419D-AB06-10C2FC1E27E5}\KEY_XE.reg.
The file does not appear to exist.

Solution:
The physical file isn’t missing, what happen was that the installer didn’t write the Registry Key’s Data value. Simply go in and add the missing value.

Join me on Facebook Follow me on Twitter Subscribe to RSS Connect with me on Linkedin Free Microsoft BI training Help Fight the Cause