Travis Tran

Travis Tran


Install Windows 10 from a USB Flash Drive

I’m writing this because I can, for some reason, never remember how to use Diskpart. And who uses DVD’s anymore? Download the Windows 10 preview ISO from here:

Insert a usb drive at least 4gb in size

Open a command prompt as administrator

Hit Windows Key, type cmd and hit Ctrl+Shift+Enter. This will force it to open as admin.

Run diskpart

This will open and run the Diskpart command line utility, which allows you to manage disks, partitions and volumes.

C:\Windows\system32> diskpart

Run list disk

This will list all disks on your system. You’ll see the something similar to this:

DISKPART> list disk

  Disk ###  Status         Size     Free     Dyn  Gpt
  --------  -------------  -------  -------  ---  ---
  Disk 0    Online          238 GB      0 B
  Disk 1    Online          465 GB      0 B
  Disk 2    Online           29 GB      0 B

Select your flash drive by running select disk #

Find the item that corresponds with your flash drive and select the disk. In the example above, my flash drive is disk 2 so I’ll run:

DISKPART> select disk 2

Disk 2 is now the selected disk.

Run clean

WARNING: This deletes all data on your drive

The clean command marks all data on the drive as deleted and therefore removes all partitions and volumes. Make sure you want to do this! If you are sure, run:


Create a partition

 DISKPART> create partition primary

Select the new partition

Since we know there is only one partition, we can just run this:

DISKPART> select partition 1

Without checking the partition number. If you’re really curious, run list partition to check.

Format the partition

To format it, we’ll use the NTFS file system and run a quick format:

DISKPART> format fs=ntfs quick

Set the current partition as Active


DISKPART> active

Exit diskpart

Run exit. This will exit diskpart, but leave the command window open.

Mount your ISO

Use Virtual CloneDrive or similar.

Navigate to the mounted image and install a bootsector

My ISO is mounted as G:\, so I’ll navigate to G:\boot and run:

C:Windowssystem32> G:
G:\> cd boot
G:\boot> bootsect.exe /nt60 E:

Where E:\ in this case is my flash drive’s letter.

Copy the entire contents of the ISO to your flash drive

You can either do this from Windows using Ctrl+C+Ctrl+V, or from the command line using xcopy.

G:\> xcopy g:\*.* e:\ /E /H /F

/E copies all subfolders, /H copies all hidden files and /F displays all source and destination file names as it’s copying.

Once that’s done, go and install Windows!


Sử dụng iptables trên CentOS

Bài viết này hướng dẫn về cách cài đặt và cấu hình iptables trên CentOS.
Tới thời điểm hiện tại, tuy rằng CentOS 7 sử dụng firewalld làm công cụ thiết lập các chính sách mạng cho server linux, nhưng mình vẫn quen sử dụng iptables hơn.

Continue reading

Install Gnome 3 GUI on RHEL, CentOS

Kiểm tra yum package đã có sẵn gói cài đặt giao diện hay chưa bằng lệnh:

sudo yum group list

Cài đặt gói giao diện:

sudo yum -y groupinstall "GNOME Desktop" "Graphical Administration Tools"
sudo ln -sf /lib/systemd/system/ /etc/systemd/system/

Continue reading

Open port for SQL Server remote connection

Ports and protocols used by Microsoft SQL Server database engine (SQLServer).

About this task

Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) which is used by Microsoft. You need to allow distant users to connect to the SQL server so they can address it their queries.
SQL Server is used by:

Continue reading

Restoring database from .mdf and .ldf files of SQL Server 2008

  1. First Put the .mdf and .ldf file in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ folder
  2. Then go to sql software , Right-click “Databases” and click the “Attach” option to open the Attach Databases dialog box
  3. Click the “Add” button to open and Locate Database Files From C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\folder
  4. Click the “OK” button. SQL Server Management Studio loads the database from the .MDF file.

Continue reading

Solving SQL Server Connection Problem

Inspect Server Settings

There are three significant aspects that users may neglect, which lead to the failure of the connection to the SQL Server.

Enable TCP/IP Connection

To check whether your server enabled to TCP/IP connections:

Continue reading

Uninstall Oracle DB on Windows completely


  1. START -> RUN -> Services.msc
  2. Locate all Ora* services & click on STOP
  3. Start -> RUN -> Regedit
  4. Locate HKEY_LOCAL_MACHINE folder in the registry
  5. Open Software folder
  6. Delete the Oracle folder under Software
  7. Open System folder in HKEY_LOCAL_MACHINE
  8. Open CurrentControlSet folder within the System folder
  9. Open Services
  10. Delete all keys related to Oracle. Every key starts with “ORA..”
  11. Close the regedit
  12. Delete ORACLE_HOME folder
  13. Delete the Oracle folder in Program Files
  14. Reboot

Uninstall all Oracle components using the Oracle Universal Installer (OUI).

Continue reading
Glad to have you at
Welcome to TravisBot