java 1.8 32bit

To check java version on window:
1) From "programs and features", if there is 64 bit, it will show 64 bit else just show java.



2) With "java -version" Comman,.if 64 bit, it will show "Java HotSpot 64-bit Server VM", else just show java version.

Update Microsoft SQL Server 2016 SP2 fail.

Install offline file: SQLServer2016-KB4527378-x64.exe
When i try to update SqlServer2016 Sp1 to SP2 (CU11) it fail. and the error msg show

The version of SQL Server instance MSSQLSERVER does not match the version expected by the SQL Server update. The installed SQL Server product version is 13.0.4001.0, and the expected SQL Server version is 13.2.5026.0.

So  I try to downgrade to 13.0.1601.5 RTM but it is still not match error.
Try to update another patch and  it worked for SQLServer2016-KB4037357-x64.exe (13.0.1708.0 RTM). but from here wanna upgrade to SP2(CU11) is still error.

Then i try install this  and its passed(SQLServer2016SP2-KB4052908-x64-ENU.exe).

Version show as:
Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64)   Mar 18 2018 09:11:49   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) 

Then restart and install the above patch. Done!

Command schtasks

For schtasks command, Do not put "/RP" with u wanna use "/IT". it might not work.

eg.
schtasks /CREATE /S 192.168.1.10 /RU ru_name /TN 123test /SC ONCE /TR "Powershell.exe D:\test123.ps1" /ST 13:00 /SD 10/10/2016 /IT /f /RL highest

schtasks /CREATE /TN 123test /SC ONCE /TR "Powershell.exe D:\test123.ps1" /ST 13:00 /SD 10/10/2016 /IT

remote problem RDP

WIN10 remote to old protocol.

Access denied : get-childitem

i get access denied well running get-childitem (powershell) as administrator.
try many way not solve the problem.
RESTART computer solve my problem.

Godaddy.com is shit

godaddy service is shit. many people compliant.
and the support more damn. i will never go for it anymore.

如果雅虎还是雅虎

如果雅虎还是雅虎，会死得好男看。
今天的雅虎， 给我的感觉就好像一动不如一静。好像烂泥上不了墙，想帮他都帮不了。
那么多年我都还支持它，今天有点失望。
看他的新闻，常会收购那家公司什么的， 策列还不错。
以前都还有用它的搜索，电邮。
搜索少用了，还有用电邮。现在看来电邮也不行了。
之前有时不能用，还可换换别的浏览器. 现在换了几个，试了很多很多次。就是有问题， 越改越差的。

Comodo not allow the IP which allow.

When u set allow a host.in firewall. eg. hostname.no-ip.org
Once this host's ip is change.
Firewall possible will not allow the new IP. it will prompt to user. -_- !!
Suspect we not update the IP in time and firewall got the new IP without any rules. then after u update the host's IP. firewall very persistent , and stick to prompt to user.

Allow Ping

To allow ping at comodo firewall, due to it automatic create some of the rules and blocking the ping.
Due to the rules "black all unmatch" at system process (application part)
just add a rules "allow ICMP echo request" at system process (application part) will do.

miui firmware

Yes, confirmed, there is no OFF button when press the power button. (v4.4.25)
and the import of contact, it only able to import vcard. and after import contact, all the row keep show at notification bar, due to  there is a row (probabbly last contact to import) is not done (well, actually it is imported, as i check)

update miui 4.4.25 already have OFF button. red color.

cyanogenmod

cyanogenmod v11.
the contact need to improve. poor of sync/management. merge/duplicate function.
the phone/sms need to improve. log/contact linkage very poor. call 1 app, sms 1 app.
language ....if u are single language user should be ok.
others, so far so good.

DDWRT to linksys E1200v2

update at 2014-02-20
currently DD-WRT for linksys E1200v2 only able to flash by mini (small) version only.
same to E1200v1

DD-WRT broadcast problem

I found that there is many people facing DD-WRT wireless broadcast problem. here is some temp solution.
i put there command: wl up
as pic below.

Android Flash ROM

When flash a ROM, not simply delete/format the system folder (/system). it content all ROM/OS file, once delete it you can not access the OS.
How if accidentally deleted it when flashing a ROM.

1) Flash the ROM as normal flow. but most of time you are delete those ROM.zip file as well. then can go for second step.
2) Flash the ROM from ext-sdcard (memory stick). copy the file(ROM.zip) to ext-sdcard and flash the new ROM. but how if the file is not there and can not copy to there at that moment.
3)  adb command.
- go to recovery mode.
- command sample to copy the file (ROM.zip) to sdcard.
adb push D:\4\SuperNexus-3.0-i9500-BUILD1.zip /sdcard/0/SuperNexus-3.0-i9500-BUILD1.zip
adb push D:\4\gapps-jb-20130813-signed.zip /sdcard/0/gapps-jb-20130813-signed.zip
4) Try install sideload.

You can always backup the file to sdcard first.
** base on CWM recovery mode.

Backup Wechat amr file

Remember not to click delete. else your amr file will physically remove.

Add route success but not show at route print

When you try to add a route
eg. route add -4 192.168.10.0 MASK 255.255.255.0 192.168.20.0 METRIC 10 IF 10

Message show success added.
but when you route print it not show.
please check the interface is correct or wrong.
you might be add to wrong interface. or the interface is not active. that why it not show.

Wechat 5.0

Wechat 5.0 can not delete personal (1 to 1) chat room.

update:
old version- press and hold the char room
5.0- strike/drag from left to right. there have delete button.

mircosoft bug kut

found that sp_trace_setfilter for NULL from sql2008R2 sp1 not work.

eg. EXEC sp_trace_setfilter @TraceID, 1, 0, 1, NULL

system Database sample

You can download sql server 2008 R2 (ver: 10.50.2500 )system databases sample here.
with chinese_PRC_CI_AS.

link: https://docs.google.com/file/d/0B40y8vVrGmAnU0RSRkVjMjhXdFk

content: master.bak, model.bak, tempdb.mdf and tempdb.ldf

DATENAME not work

SQL server 2008 SP3 not work for this : select DATENAME(month, '2012-07-01')
it will show result 07 instead of JUL.
well, sql server 2008 R2 working fine.