John Liu Blog

Every drop counts

VMWare p2v keyboard not working

After converting a physical laptop into a VMWare Workstation, the keyboard might not working. To fix this problem, simply edit following registry entry UpperFilters data value to be ONLY kbdclass. Remove any thing else before or after kbdclass, such as SynTP etc.. This worked for Lenovo laptop. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Class{4D36E96B-E325-11CE-BFC1-08002BE10318} To be able to modify the registry “without” keyboard, simply using the in-built soft keyboard (On-Screen Keyboard) under All Programs –> Accessories –> Ease of Access –> On-Screen Keyboard

Effectively mapping primary key – foreign key relations

To properly locating the primary key - foreign key relations in a database sounds like a tough task. Mohit Nayyar posted a technique to find out primary key and foreign key that have the same column names. The limitation of that is that, in reality, column names are not always the same in a database. For example, in the AdvantureWorks sample database in SQL2005, the SalesPersonID in Sales.SalesPerson table has a foreign key reference to the EmployeeID column in the HumanResources.

Posts Archive

Archive of historical posts.