John Liu Blog

Every drop counts

SQL Playground Setup

This post descript the steps to setup a SQL Server failover cluster playground environment. Create a base server template VM of Windows Server 2022, with features .Net Framwork 3.5.1, Failover Clustering, and Multipath I/O installed via the Server Manager. Assign 4 Network Adapters, with the first adapter using NAT. Once the template server setup is done, run sysprep from cmd. The options for sysprep should be set to “Enter System Out-of-Box Experience (OOBE)” and the checkbox for Generalize should be checked, and set Shutdown option as Shutdown.

Run VMWare and Docker on the same computer

You can install VMWare Workstation (v15.4 or earlier) and Docker on the same computer, but they can’t be run at the same time due to VMWare and Hyper-V can’t be run at the same time. Docker depends on Hyper-V. To run VMWare Workstation, turn off Windows features “Virtual Macine Platfrorm” and “Microsoft-Hyper-V-All” and then restart computer. PS C:\> Disable-WindowsOptionalFeature -Online -FeatureName "Microsoft-Hyper-V-All" -NoRestart PS C:\> Disable-WindowsOptionalFeature -Online -FeatureName "VirtualMachinePlatform" To run Docker, turn on Windows feature “Virtual Macine Platfrorm” and “Microsoft-Hyper-V-All” and then restart computer.

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