How To Create a Windows 7 Password Reset Disk?

Hi Everyone,

If you have tendancy to forget your windows password. Better create a Winows 7 Password Recovery Disk. With it, you can easily reset your Windows 7 password and forgetting your password is no longer a nightmare.

Here is how we create Windows 7 Password Reset Disk.

1. Click on Start and then Control Panel in Windows 7.

2. If you are seeing Category View, Click on the User Accounts and Family Safety link and then click on the User Accounts link.

Note: If you are seeing Large/Small Icons view, click on the User Accounts icon and proceed.
Click on the User Accounts link.

3. You need a USB Flash Drive or Floppy disk to create the Password Reset Disk. You will not be able to create a Windows 7 password reset disk on a CD, DVD, or external hard drive.

4. In the task pane on the left, click the Create a password reset disk link.

5. When the Forgotten Password Wizard window appears, insert a USB Flash Drive and click Next.

6. In the I want to create a password key disk in the following drive: drop down box, choose the portable media drive to create a Windows 7 password reset disk on.

7. Click Next to continue.

8. With the disk or other media still in the drive, enter your current account password in the text box and click Next.

9. Windows 7 will now create the password reset disk on your chosen media.

10. When the progress indicator shows 100% complete, click Next and then click Finish in the next window.

11. You can now remove the flash drive from your computer.

Please keep it in a safe place since anyone with this disk can reset your password.

Thanks for reading my blog !

Read More

How To Change Drive Letters in Windows 7?

Hi Everyone,

If you want to change the drive letter of your choice of the hard drive partition in your computer. I have solution here. Note that you cannot change the drive letter of the partition that Windows 7 is installed on. In a normal Windows 7 system, this is the C drive.

Here are those simple steps to change a drive letter in Windows 7:

1. Open Run window by pressing Win+R key.

2. Type diskmgmt.msc and hit enter to open Windows 7 Disk Management.

Note: You can also open Disk Management from the Computer Management utility.

3. On the right-hand side of the screen, locate and right-click on the drive that you wish to change the drive letter of and choose Change Drive Letter and Paths option.

4. In the Change Drive Letter and Paths window, click on the Change button.

5. The Change Drive Letter or Path dialog box will appear.

6. Choose the drive letter you wish to assign to this drive by clicking the letter from the drop-down box on the right.

7. Click OK.

8. The Disk Management window that appears advises you that "Some programs that rely on drive letters might not run correctly. Do you want to continue?".

Note: If you have software installed to this drive, the software may stop functioning after a drive letter change. Nearly all software defaults to the primary drive though, so this is rarely a concern.

9. Click Yes, If you are sure you want to make this change.

10. We are done and Now you can now close the Disk Management window.

Thanks for reading my blog !

Read More

How to create a Windows 8 Recovery Drive?

A Windows 8 Recovery Drive allows you to access Advanced Start-up Options. It contains troubleshooting tools for Windows 8 like Command Prompt, System Restore, Refresh Your PC, Rest Your PC, Automatic Repair, etc.

Once we have a newly installed Windows 8 Operating System, the user should create a Recovery Drive. It can be created from any working Windows 8 operating system (Not necessary to create from your own machine). It is same as the System Repair Disc created for the Windows 7 (Available in my Previous Blog).

How To Create a Windows 7 System Repair Disc?

Lets start with the process.

Here are the steps:

1. Open the Windows 8 Control Panel. Windows 8 includes a tool to create a Recovery Drive and very easy to access from the Control Panel.

2. Touch or click on the System and Security link.
Note: You won't see System and Security if your Control Panel view is set to Large icons or Small icons. In your case, just tap or click on Recovery and then move on to Step 5.

3. In the System and Security window, Touch or click on the Action Center link at the top.

4. In the Action Center window, Touch or click on Recovery, located at the bottom of the window.

5. In the Recovery window, Touch or click on the Create a recovery drive link.

6. Connect the flash drive as the Windows 8 Recovery Drive to the USB port. Disconnect all other external drives. It is only to avoid confusion in later steps.

7. Check the Copy the recovery partition from the PC to the recovery drive check box if it is available.

8. Touch or click on the Next button. Wait while Recovery Drive Creator searches for drives available to be used as a Recovery Drive.

9. On the Select the USB flash drive screen, choose the drive letter that corresponds to the flash drive you want to use as a Windows 8 Recovery Drive. Touch or click on the Next button.

10. Touch or click on the Create button to begin the Recovery Drive creation process.
Important: Please take note of the warning on this screen: Everything on the drive will be deleted. Please make sure you have backed up the personal files on this drive if any, before you Touch or click Create button.

11. Wait while Windows 8 creates the Recovery Drive, which involves formatting the flash drive and then copying the necessary files to it.

12. When the Recovery Drive creation process is complete, you will see a The recovery drive is ready message. Touch or click on the Finish button.

Thanks for reading blog !

Read More

Windows 7 - How To Create a Windows 7 System Repair Disc ?

Hi Everyone,

A Windows 7 System Repair Disc enables you access to Windows 7's System Recovery Options. It is a powerful set of Microsoft in-built diagnostic and repair utilities.

It is highly advisable to create a System Repair Disc. With a System Repair Disc, you can access Windows 7 diagnostic tools like Startup Repair, System Restore, System Image Recovery, Windows Memory Diagnostic, and Command Prompt. System repair Disc should be stored in a Optical Disc rather USB Flash drive.

Here are the steps to create a Windows 7 System Repair Disc:

1. Open Run window by pressing Win+R key.

2. Type recdisc and hit enter.

Note: This can be accessed also from the start menu. Start -> All Programs -> Maintenance -> Create a System Repair Disc

3. Choose your optical disc drive from the Drive: drop-down box.

4. Insert a blank disc in your optical drive. Make sure the blank CD/DVD shoould have enough space. The size of System repair Disc will be less than 200 MB.

5. Click the Create disc button. Now Windows 7 will create the System Repair Disc. No special disc burning software is required.

6. Once the System Repair Disc creation is complete, Windows 7 displays a dialog box that you can close by clicking the Close button.

7. Click the OK button on the original Create a system repair disc window.

Now our System Recovery Disc is ready to be used.

Thanks for reading my blog !

Read More

Windows - How to use bootsect command to fix the boot issues?

Hi Everyone,

 

We might have come across operating system boot issues. Usually hal.dll errors in Windows 7, 8, and Vista. Here is the windows in-built solution to fix the volume boot record errors. 

Boot Sector restoring program is available in windows which is bootsect command. It is a command line program available from Advanced Startup Options or System Recovery Options. The entire operation may take 10-15 minutes.

Here is how we fix these errors,

1. Open the Advanced Startup Options (Windows 8) or boot to the System Recovery Options menu (Windows 7 & Vista) (Which can be accessed by booting from the OS Installation Disc).

Another Option is to Create a Windows 8 Recovery Drive or How To Create a Windows 7 System Repair Disc (You may expect these topics in the future posts)

2. Go to  Command Prompt from the Advanced Startup Option

3. At the prompt, type the bootsect command as shown below and then press Enter:

bootsect /nt60 sys

The above bootsect command will update the volume boot code on the partition used to boot Windows to BOOTMGR which is compatible with Windows Vista, Windows 7, Windows 8, and later Windows operating systems.

Here nt60 switch applies the boot code for BOOTMGR (Windows Vista, Windows 7, Windows 8, and later Windows operating systems) while the nt52 switch applies the boot code for NTLDR (Other versions of windows).

4. After running the bootsect command as shown in the last step, you should see a result that looks something like this:

C: (\\?\Volume{33a450c8-2331-12e0-6015-706e6f6e6563})
Successfully updated NTFS filesystem bootcode. 
Bootcode was successfully updated on all targeted volumes.

If you get some kind of error, or this option doesn't work after you restart Windows normally again, try running bootsect /nt60 all command instead. 

5. Exit from the Command Prompt window and then remove the Windows disc from your optical drive or the Windows flash drive from its USB port.

6. Select the Restart button from the System Recovery Options window or click Continue from the main Advanced Startup Options screen.

7. And now you have your Windows boot normally.

If you still get any errors, try the command bootsect /nt60 all  given in the step 4.

Thanks for reading my blog !

Read More

Windows - Install Windows Operating System from USB Drive

Hi Everybody,

I am here to explain you how to install an operating system if you don't have a DVD Drive in your computer. Most of the computers shipped with USB ports and USB boot option available in the BIOS. Before we start with this make sure you set the following configurations.

• Enable USB boot in the BIOS
• Change the Boot priority to boot from the other devices (NOT DVD Drive / Hard Drive).

Please see the Mother Board / BIOS Manual if you have any doubts in setting the above configurations.

This is all about the hardware settings, now we will discuss the windows part of it.

diskpart command is used to make a USB Drive a bootable OS package.

 Follow the below simple steps to get this done.

1. Open Run window by pressing Win+R key.

2. Type cmd and hit enter.

3. Now we have the Command Prompt, type diskpart and hit enter.

4. List the disk drives connected to the computer.

list disk

5. Select the Connected USB disk from the list (If you have doubt on disk selection, cross check the size of disk and size shown in the list).

select disk 1

Note: This site will not be responsible for any data loss due to wrong selection of disk.

If you want to see the details about the disk use the below command.

detail disk

6. Removes existing partition or volume formatting from the disk with the below command.

clean

7. Create a primary partition in the current select disk.

create partition primary

8. Select the created partition.

select partition 1

9. Make the selected partition active.

active

10. Format the partition with the appropriate file system. For windows, FAT32 file system.

format fs=fat32

11. Assign the drive letter to the new partition.

assign

Now our USB drive is ready to copy the Operating System disk content.

12. Exit from the diskpart

exit

13. Copy the OS Installation Disk content to the USB Drive. We use XCOPY command to copy the contents.

xcopy K:\*.* /s/e/f L:\

Here K:\ is the root folder with the OS Installation files and L:\ is the USB Drive.

14. Plug the USB Drive, Boot from it and complete the installation.

Thanks for reading my Blog !

Read More

Oracle – Hierarchical Queries

Hi Everyone,

I am here to explain the Oracle Hierarchical queries with the help of an example.

Oracle stores data in terms of records and there is no mechanism to store data in hierarchically. But there are methods available in Oracle 11g package to relate and display the hierarchical data. I will introduce a Sample Table TBL_ORGN, which stores the reporting structure of organization.

--Creates table

CREATE TABLE TBL_ORGN

(

                EMPID NUMBER,

                ENAME VARCHAR2(100),

                MGRID NUMBER

);

--Inserts records into the table

BEGIN

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (1, 'SAM',NULL);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (2,'JIM',1);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (3,'GREG',1);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (4,'HARRY',2);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (5,'SHANE',3);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (6,'HILTON',3);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (7,'CHRIS',2);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (8,'JENNA',4);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (9,'MARK',5);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (10,'ANGEL',6);

INSERT INTO TBL_ORGN (EMPID, ENAME, MGRID) VALUES (11,'JANE',7);

END;

--Select the records

SELECT * FROM TBL_ORGN;

If we need to know who is reporting to JIM.

SELECT EMPID, ENAME FROM TBL_ORGN WHERE MGRID=2;

But if we need to know all the employees working under JIM. Oracle helps to traverse the hierarchical data in the table. There are some keywords used for this.

START WITH

It specifies the start of the hierarchy. In this example, JIM’s record in the starting point in the hierarchy.

CONNECT BY PRIOR

It defines how two records are related. In this example, EMPID (child) and MGRID (parent) are related.

PRIOR

This is used to achieve the traversal of the hierarchical data in the table.

SELECT

EMPID, ENAME, MGRID, LEVEL

FROM TBL_ORGN

START WITH EMPID = 2 --JIM'S ID

CONNECT BY PRIOR EMPID = MGRID

ORDER BY LEVEL, EMPID

Direction of the Data Traversal

The direction of the traversal is decided by how we set the child-parent relation in the CONNECT BY PRIOR clause.

In the above example, it gives a downward reporting structure. i.e. employees under JIM.

If we need to know who are the reporting managers of JIM.

SELECT

EMPID, ENAME, MGRID

FROM TBL_ORGN

START WITH EMPID = 2 --JIM'S ID

CONNECT BY PRIOR MGRID = EMPID

ORDER BY EMPID

Thanks for reading my Blog !

Read More