[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

[SQL] note – FILESTREAM course practice

• Keep your version of SQL Server and Operation System on the same bits (32-bits or 64-bits)
• open SQL Server Configuration Manager
• Right click your instance of SQL server –> Propertites

[Life] – An essential technical sense is important for a person to operate a computer

Recently we upgraded/replaced the new terminal for our company

A lady who’ve been working for our company for several yrs

[SQL] Use LinkServer connect to IBM AS400

 

Install IBM iSeries Navigator, make sure “iSeries Access for Windows .NET provider” option is checked

If you don’t have the CD-Row, please go to here to order