Error:
Cisco VPN is not working (cannot login and connect to VPN connection).
Solution:
1. Right-click on the VPN client, and Run as Administrator.
2. Open regedit and go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\CVirtA and rename:
x86 - "@oem8.ifn,%CVirtA_Desc%;Cisco Systems VPN Adapter" to "Cisco Systems VPN Adapter"
x64 - "@oem8.ifn,%CVirtA_Desc%;Cisco...
Monday, October 24, 2016
Monday, June 20, 2016
Find Maximum Value from Multiple Columns
A colleague asked about how to get maximum value from multiple columns. After searching it online, I found a pretty good way to get it, and thought it would be good to share here.
For example, I have a table with MemberID and 3 date fields. I want to get the last date from...
Friday, January 22, 2016
Calculating Customer's Latency
There were times when I was asked to retrieve the latency of the customers in my work. At first, I was confused about how to retrieve this. After some thought, I find a solution, which is actually pretty simple, and the SQL usage is widely available. Unfortunately, when I tried...
