[SSD]Migrate System from Tranditional Hard Disk to SSD

Situation:
My PC's OS is Windows Server 2012 and has a Hyper-V that included 3 SQL server inside, recently I bought a SSD driver, and prepare migrate it to SSD


Tools:

• Symantec Ghost 15
• Old Hard Disk
• New SSD
• Dell PC

[Hyper-V] VMs can not join Domain

1. check out the log, it located at
    C:\Windows\debug\dcdiag.txt
2. Add this DNS address to your network
3. Reboot your PC and join again.

[SQL] I am confused about “Snapshot” “Mirror” “Replication” and “Failover Clustering”

Recently I am reviewing these solution in my environment. For my company, we already built the stable SQL server and rarely to look at what kind of solution is the best for us.
Just for my understanding and I still have lots knowledge needed to know
Replication)

[NetWork] Network Adapter unable to get LAN or WAN but show available , Ipv4 is disabled

Ipv4 is disabled
It’s happened recently. One PC just suddenly lost the internet connection. The network adapter is available but unable to connect to any LAN or WAN.
And the IPv4 is uninstalled already. The first thought coming was a “Virus”.
So I did this:
GO to the network adapter Properties

[SQL] Online Index Rebuild while you r doing SELECT

This address of MSDN descript detail theory. HERE. And I did a test on it

[SQL]Index–Fill Factor- simple practice

The is the difinition
http://technet.microsoft.com/en-us/library/ms177459.aspx
I use the sample DB and Table is AdventureWorks2012::person.address

[Life] Thank you God, I passed the exam MCSA for SQL Server 2012

[SQL] I’ve learned a good definition for “Isolation Level” from SQL Server 2012 Training Kit

It prevents pending changeds from more highly isolated transactions from being overwritten

[Life] updated slowly…cuz I am preparing MCSA exam

Focusing on SSIS
http://msdn.microsoft.com/en-us/library/bb522537.aspx

[CMD] The process cannot access the file because it is being used by another precess

Situation:

I created a “batch” file for transfering data from Mainframe to PC and run a VBSCript to do something.

Today when I did this, it showed this up and I use “unLock” tool to check, there was none a process occupying this program