Profile cover photo
Profile photo
Sing-Cheong Chen
55 followers
55 followers
About
Communities and Collections
View all
Posts

Post has attachment
Kwikset Electronic Deadbolt Lock Review
Manufacturer: Kwikset Product:  All electronic deadbolt locks, all smart locks Battery operated devices has been around easily for more than 50 years.  In past 10 years, residential door locks have been slowly adapting the electronic locks due to the popula...
Add a comment...

Post has attachment
Windows: How to Disable Auto Startup
Windows: How to Disable Auto Startup of Any Programs Overview Windows Version: 95, 98, XP, Vista, 7, 2008, 2008R2, 2012, 2016 Many virus and applications will auto startup during OS boot up.  This includes: 3rd Party Firewall - an upgrade might block intern...
Add a comment...

Post has attachment
BMW: Enabling/Disabling Auto Door Lock
BMW E46, E60, E90, E91, E92, E36 You can enable auto door lock for BMW cars in 1980's - 2000's using the remote control key, and doesn't need to pay dealer to enable/disable the feature. These cars can auto lock all the car doors after the car's speed is ab...
Add a comment...

Post has attachment
MS SQL Server: Verify Login Timeout
Product: MS SQL Server Version: 2000 - 2016 Microsoft MS SQL Server pre-install with login timeout of 10sec.  Many developers or support personnel might have a chance to encounter login timeout while DBA might tell you that there is no login timeout, as the...
Add a comment...

Post has attachment
How to Maintain Old Cars?
Following is a preventive maintenance for old cars with budget conscious, as most old car owner are in control of their financial spending.  This mainly for 8 - 30 yr old Japanese car, i.e. Honda and Toyota, as they are more reliable and have shorter list t...
Add a comment...

Post has attachment
How to Choose Thermostat?
How to Choose a Residential Thermostat? This post is about choosing and installing a residential universal thermostat for most homes in Canada and USA with central force air HVAC.  All the houses that build in 1980 and furnace and A/C sold since 1990 are us...
How to Choose Thermostat?
How to Choose Thermostat?
singcheong.blogspot.com
Add a comment...

Post has attachment
MS SQL Server: Ver 2014 – CXPACKET – Parallelism
Product: MS SQL Server 2014 Version: Base version, SP1, SP2 (latest), or SP2 with various patches (as of Jul 2017) Edition: Standard, Enterprise This post is about MS SQL Server 2014 parallel query bug that rarely & randomly occurs which causes long executi...
Add a comment...

Post has attachment
Oracle: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Product: Oracle Database Version: 12.1.0.2 Oracle 12c introduced a new parameter called PGA_Aggregate_Limit , which is a global PGA memory control to prevent RAM contention and virtual memory swapping to disk. Previous parameter PGA_Aggregate_Target is only...
Add a comment...

Post has attachment
MS SQL Server: Finding JDBC Version
Product: MS SQL Server Version: 2008R2 - 2014 Every Microsoft JDBC JAR version bundled with 4 sqljdbc.jar files for 4 different versions of major Java JVM.  When you download the driver from Microsoft, it will include 4 JAR files, and you need to pick the p...
Add a comment...

Post has attachment
PowerShell: Rename File but Keep Extension Name
Dir -recurse | where { ! $.PSIsContainer } | Rename-Item –NewName { $.Basename.TrimEnd() + $_.extension } -verbose  
Add a comment...
Wait while more posts are being loaded