2017年11月14日 星期二

DELL Wireless is disabled when Ethernet is connected


Hi peter_sgc,
Thanks for the post! The Latitude E5440 systems can be configured to enable/disable connection to through a wireless network if configured in the systems BIOS.  
The setting can be found by entering your systems BIOS (Restarting the system and pressing <F12>When the Dell logo appears on screen)
Navigating to Power Management >> Wireless Radio Control

Here you can enable / disable the feature to sense the systems connection to a wired network and subsequently disable the selected wireless radios (WLAN and/or WWAN)

2017年10月18日 星期三

Delta Vs C700 for IT

Delta A104 A105 non RHoS VF 7
                                                      8
                                                      9
          A106 A107 > or = VF9  (for only VF9.0.1)

C700 for IT MK  no problem

C700 for IT MS VF8  (for only VF9-pure-only)

2017年9月28日 星期四

Cisco Switch Office Pocket Guide for Cisco & HP Hardware

Example Central (ICS and MVWS > VF6) in VLAN 1:
switch#configure terminal
switch(config)#interface fa0/<Port number>
switch(config-if)#description Central
switch(config-if)#switchport access vlan 1
switch(config-if)#speed 100
switch(config-if)#duplex full
switch(config-if)#switchport host

Ans : This MACRO does 3 things.
1. switchport mode access
2. spanning-tree portfast
3. disables port-channeling.

2017年9月12日 星期二

configuring wpa2 psk on autonomous AP?



https://learningnetwork.cisco.com/thread/81423

Hi Conwyn,

Thanks for the response.
From which prompt would we enable the encryption type? This is not been listed on any of the prompts for the autonomous AP that is with me.
ap(config)#dot11 ssid guest1
ap(config-ssid)#vlan 44
ap(config-ssid)#authen
ap(config-ssid)#authentication ke
ap(config-ssid)#authentication ?
  client          EAP client information
  key-management  key management
  network-eap     leap method
  open            open method
  shared          shared method
ap(config-ssid)#authentication open
ap(config-ssid)#authentication key-management wpa version 2
ap(config-ssid)#mbssid guest-mode
ap(config-ssid)#wpa-psk ascii ?
  0     Specifies an UNENCRYPTED key will follow
  7     Specifies a HIDDEN key will follow
  LINE  Clear WPA password
ap(config-ssid)#wpa-psk ascii 0 1234567890
ap(config)#dot11 ssid guest1
ap(config-ssid)#vlan 44
ap(config-ssid)#authen
ap(config-ssid)#authentication ke
ap(config-ssid)#authentication ?
  client          EAP client information
  key-management  key management
  network-eap     leap method
  open            open method
  shared          shared method

ap(config-ssid)#authentication open
ap(config-ssid)#authentication key-management wpa version 2
ap(config-ssid)#mbssid guest-mode
ap(config-ssid)#wpa-psk ascii ?
  0     Specifies an UNENCRYPTED key will follow
  7     Specifies a HIDDEN key will follow
  LINE  Clear WPA password

ap(config-ssid)#wpa-psk ascii 0 1234567890

ap(config)#dot11 ssid guest1
ap(config-ssid)#encr
ap(config-ssid)#?
ssid configuration commands:
  11w-pmf              11w PMF Client Configuration
  accounting           radius accounting
  authentication       authentication method
  band-select          enable band select
  dot1x                SSID Config Commands for IEEE 802.1X
  exit                 Exit from ssid sub mode
  guest-mode           guest ssid
  ids                  IDS MFP Client Configuration
  information-element  Add information element
  infrastructure-ssid  ssid used to associate to other infrastructure devices
  ip                   IP options
  max-associations     set maximum associations for ssid
  mbssid               Multiple BSSID
  mobility             enable L3 mobility
  no                   Negate a command or set its defaults
  rate_limit           Dot11 Rate_Limitr Configuration Options
  vlan                 bind ssid to vlan
  web-auth             Web Authentication
  wpa-psk              Configure Wi-Fi Protected Access pre-shared key
  xconnect             tunnel incoming frames

ap(config-ssid)#end

2017年9月6日 星期三

Wan Chai Site , : Excessive CRC/Alignment Errors



Hi,
Excessive CRC... means a bad negotiation.
Is port speed/duplex correct ?
Disable lacp on port that do not need i.



Re: Excessive CRC/Alignment Errors on port 19

First of all you should to check the cable connected to the port. Do not trust multimeters - use normal network analizer to measure NEXT, attenuations, wrong pairing etc.
Next, check the speed/duplex settings on both sides.
Next, monitor network traffic of your host, connected to the port. You can use WireShark (freeware tools, Google for it) for this purpose (it is available for *NIX and Windows as well).
Next localize the application generated this traffic. Tools will depend on OS you are using.

P.S. Of course, not all steps will be mandatory ;)).

Good luck!

2017年9月3日 星期日

javascript

https://www.zhihu.com/question/19713563

首先我会把Chrome浏览器装好,在dev tools =&gt; console里直接练习熟悉基本语法,变量,数据类型,数学运算,字符串运算,条件,循环基本结构,简单函数定义和调用这些,之所以用chrome dev tools,是因为这时候我不想费劲折腾单独的编辑器,也不需要在开文件和文件夹,然后去配一些工具最终才接触到真正的JS编程,我想尽可能直接而少干扰就开始写JS,这是最重要的,我学JS,当然应该尽快写JS

45 down vote accepted
  1. Go to chrome://flags/, enable the "Enable Developer Tools experiments" flag and restart Chrome (or start it with the --enable-devtools-experiments command-line flag.)
  2. Open DevTools, go to the Settings dialog, switch to the Experiments tab.
  3. Enable the "Snippets support" experiment, close and reopen DevTools.
  4. Go to the Sources panel. In the left-hand navigator sidebar, switch to the Snippets tab .
  5. Right-click in the [empty] tree in this tab, select the New context menu item.
  6. Give the new snippet any name you like and type the snippet body.
  7. Once done, click the Run (>) button in the status bar to execute the snippet body. You can set breakpoints in snippets and debug them as ordinary scripts.
http://www.bkjia.com/Javascript/1212141.html

2017年9月1日 星期五

Windows 2008 Windows Performance Monitor and Disk usage

Windows 2008 Windows Performance Monitor and Disk usage,

Now select the four counters below and we will then look what they represents.
Avg. Disk Bytes / Transfer
Avg. Disk sec / Transfer
Disk Bytes / sec
Disk Transfers / sec


Throughput is often expressed in MB/sec, but Perfmon in Windows 2003 displays this in Bytes/second, e.g. 382,090,819 meaning 382 MB/s. It would be nice to have to possibility to customize the output of this in Perfmon, but unfortunately that is not an option.

2017年8月2日 星期三

UPS

Glossary

http://deepgreat01.blogspot.hk/2015/05/ups-20150526.html

Blog

UPS的续航时间计算- 王志勇的Blog



List out

BROCHURE_UPS_Size_Cost_Worksheets_LR.pdf


http://www.vedfolnir.com/ups-uninterruptible-power-supply-system-device-buy-and-choice-advice-5978.html

工具人再以 550 瓦特(參考連結)與 1375 Watts(參考連結)這兩種電源供應器為例,兩者所需的 UPS 就有極大不同,前者挑選 1000VA/600W 差不多已經足夠,但是後者則就算挑選 1500V 機型都還不夠(除非你電腦只是拿來畫小畫家)。
2015.05.12補充:網友蕭先生在臉書提問,認為電源供應器應把能源效率(Energy Efficiency,又稱轉換效率)列入功耗計算,所以需要挑選比帳面數字更大的 UPS 才安全。關於這一部分的內容,工具人另外寫了一篇文章《電源供應器 80Plus 能源效率與不斷電系統 UPS 供應電源的問題探討》[7],歡迎有興趣的朋友可以前往閱讀。
當然,如果你對自己的電腦主機實在不太熟悉,更不清楚自己的負載耗電量,我建議一般電腦使用者只要選購跟我一樣規格的 UPS 即可。我的 UPS 只有接一台主機(電源供應器為 500W)及一台螢幕,主機裡有硬碟四顆、一張顯卡,主機後方有四組 USB 插槽,各自接有不同的周邊裝置。這樣的系統配置在一般正常使用下(沒有在跑影片剪輯之類的程式),總耗電量只有 160 瓦,就算再加上電腦螢幕也不到 200 W,完全符合 1KVA/600W 的工作範圍(有點像殺雞用牛刀 :P)。

2017年7月27日 星期四

clean you USB memory stick with diskpart

https://kb.acronis.com/sites/default/files/content/2006/3/1526/flashVista72008c.html


Creating Acronis Bootable Media on a USB Flash Drive

(!) This is not applicable to Acronis Backup & Recovery 10 Build 11639 or higher
These instructions apply to:
  • Windows 7
  • Windows Vista
  • Windows Server 2008
  1. Insert your flash drive;
  2. Hit Win-R and type cmd to open a command-line;
  3. Type diskpart to run Windows DiskPart utility:
  4. Type list disk to list all disks attached to the machine:
  5. Type select disk [number] to select your flash drive:
  6. Type clean to remove any formatting from the selected disk:
  7. Type create partition primary:
  8. Type select partition 1 to select the only partition, which you now have on the flash drive:
  9. Type active to mark the partition as active:
  10. Type format fs=fat32 to format the disk in FAT32 (otherwise the drive will not be bootable):
  11. Type assign to assign a drive letter:
  12. Type exit to exit Windows DiskPart utility:
  13. Run your Acronis product;
  14. Pick Tools -> Create Bootable Rescue Media;
  15. Follow all steps of the wizard and select your USB flash drive as media.

2017年7月21日 星期五

How can I get my Diskstation to reboot automatically

https://www.synology.com/en-uk/knowledgebase/DSM/help/DSM/AdminCenter/system_hardware_schedule

Power Schedule*

At Control Panel > Hardware & Power > Power Schedule, you can set the system to start up or shut down automatically at a specified time.

To add a new startup/shutdown schedule:

  1. Click Create button to open the Add Schedule dialog.
  2. Choose Startup or Shutdown.
  3. Set the Date and Time for startup or shutdown.
  4. Click OK.
  5. Click Save.
The new schedule will be added to the schedule list.


How can I get my Diskstation to reboot automatically

Postby Tonyel » Wed Sep 17, 2014 11:23 pm
I have a diskstation DS211j, which is storing video from a Y-Cam Bullet. However, if I leave it running for more than a week or so, it seems to stop recording video automatically, but it is OK once I have rebooted the diskstation.

Is there a way to schedule an automatic reboot of the diskstation every day, say at 9AM or something?

I tried the task scheduler, but it didn't manage to restart the diskstation after shutting it down.

Thanks in advance for any help!

Cheers,

Tony

Re: How can I get my Diskstation to reboot automatically

Postby Tonyel » Sun Sep 21, 2014 12:29 pm
Thanks for the reply. I tried this, setting the time off to be 12:10, and the time on to be 12:11. It turned off OK, but didn't turn itself back on again.

Am I doing something wrong?

Re: How can I get my Diskstation to reboot automatically

Postby Ate_Bit » Mon Sep 22, 2014 1:40 am
Also, if your unit takes more than one minute to power down, your settings won't work
NAS: DS413 running DSM 6.0
Configuration: SHR, with 1 disk data protection
HDD: 3x4TB

2017年7月19日 星期三

mirth pwhot using pre-caution

http://unicolet.blogspot.hk/2012/08/mirth-recover-space-when-mirthdb-grows.html

appdata\mirthdb\seg0

C:\Program Files\Mirth Connect\appdata\mirthdb\seg0

https://www.experts-exchange.com/questions/28694112/Derby-Database-Seg0-folder-dat-files-growing-too-large.html

Author Commentby:robthomas09
ID: 409026422015-07-28
I ended up uninstalling Mirth after exporting my channels and reinstalling mirth and all of the space freed up.


mirth 191.1.1.183 make no space for PWHOT1


As noted on our wiki, the embedded Derby database is not recommended for production use. It's meant for quick deployment, development, and testing. For production use, you should switch to one of the other supported databases (PostgreSQL, MySQL, Oracle, or SQL Server).
__________________

http://www.mirthcorp.com/community/wiki/display/mirth/System+Requirements

ePR unsubscribe

Aim to create message auto from sequential database then send

Caution , UNDEPLOY the channel after run. else 1) restart mirth will redepoly 2) keep creating file in high speed in your local harddrive. 3) eat up all your harddisk space 4) hang the mirth and no way to delete


  ALTER TABLE [PWHOT].[dbo].[sheet1]
   ALTER COLUMN patient_key nvarchar(50)

ALTER TABLE dbo.YourTable
   ALTER COLUMN YourColumnName BIT
 

How to change column datatype in SQL database without losing data


Hints: on DB Quere you can remove "[]"

How to use the Mirth Transformer

Hints :https://www.youtube.com/watch?v=nTAmnfLMO0A

SELECT a.userID, b.usersFirstName, b.usersLastName  FROM databaseA.dbo.TableA a inner join database B.dbo.TableB b  ON a.userID=b.userID

PHHOT.dbo.sheet1 = [PHHOT].[dbo].[sheet1]

Hints: java.lang.Thread.sleep(5000) on Mirth -> Destinations -> Step

How to create a table from select query result in SQL Server 2008 [duplicate]

Hints : SELECT * INTO NewTable FROM OldTable

Convert XML to HL7 messages using Mirth Connect

Hints : http://irwinj.blogspot.hk/2008/12/getting-started-with-mirth-part-1.html

HINTS: Trace: • Mirth Connect Introduction and Tutorial
http://wiki.patesco.ca/doku.php?id=hl7:mirth:tutorial

HINTS : https://amarnathks.wordpress.com/tag/mirth-beginner-tutorial/

Enable Run On Update Statement if you wish to update something after reading data from table. Here i have updated the status flag to 1 such that those details will not be read again. You can now see the selected data values in the right side of On Update SQL.


question : Is it possible to configure the File Writer to create a file name based on the PID.2 segment (chart ID) so each patient account would have it's own file for ADT messages?

HINTS: http://www.mirthproject.org/community/forums/showthread.php?t=11120
Yes, definitely. Extract the PID.2 out into a map variable, and then in the destination settings just drag your map variable into the Filename field

Transformer -> New Step -> Mapper -> change this step to "Channel Global Map"" -> set variable as filenamePatKey , and Mapping as msg['pmhgoodresult_patient_key'].toString()
then
Destination -> file writer -> on right side " Destination Mapping " you can find filenamePatKey you just create

question : mirth database reader endless loop

HINTS : isdone flag on DB for notice

2017年6月21日 星期三

sql to reduce/shrink LDF file size in SQL Server

To reduce the .ldf file, you must do three things:

  • Backup the database
  • Stop the database service
  • Shrink the .ldf file




SELECT name, physical_name AS current_file_location
FROM sys.master_files

Following is the output of files used by my SQL Server instance.

-------

Bill_Ryan
Jalapeno
Best Answer
Bill_Ryan  
In  Server Management Studio Right click on the database in question and go to Properties:
  • Go to "Options" on the left
  • Change the line "Recovery Model:" from Full to "Simple" and hit OK
  • Right click on the database again, go to Tasks - Shrink - Files
  • Under File Type: select Log and click OK
This will temporarily free up space for you, make sure that your database is set to back up and that its configured to empty the log after back up. Once you have resolved the space issue and made sure your log file is set to flush after backups, I recommend you put the recovery model back on Full. If it was already set to flush the log after backup, check to see why the backups aren't being done...
GerardMainardi
Datil
GerardMainardi  
Do you NEED that log?  If so, you've certainly got a problem.
Otherwise, you can go the ghetto solution that will take care of it in the short-term: change the database recovery model to simple, then change it back and set a new log size. (Right click database, properties, options, recovery model).
Let me know if you need more detailed instructions than this.  You'll lose all that transaction log, but this will do it.
EDIT: Bill beat me to it

2017年6月8日 星期四

HTC One X One X General [LIST] HTC secret codes for HTC One X

https://forum.xda-developers.com/showthread.php?t=1683634

General codes
  • *#06# = Show IMEI
  • *135# = Show mobile number


HTC specific codes
  • *#*#4636#*#* = device information program (such as telephone, battery, wifi, ...) << all these generic system information tools in the market read the same data as this code/tool does - [working]
  • *#*#7262626#*#* = Field-Test
  • *#*#3424#*#* = HTC Function Test program (very useful!) - [working]

The Beginner's Guide to Linux Disk Utilities - How-To Geek

Gparted :
whoami user
su -u user
password : live

sudo -s fdisk -l


the-beginners-guide-to-linux-disk-utilities/
There are two ways to detect bad sectors in Linux: you can use the Disk Utility GUI, or if you are a command line geek like us, you can use the badblocks command to check your hard disk for bad sectors:
sudo badblocks -v /dev/sdb1

2017年5月22日 星期一

PowerPC Emu

https://stackoverflow.com/questions/8971839/powerpc-emulation-qemu-pearpc-or

http://lassauge.free.fr/qemu/

2017年5月13日 星期六

wannacry

Patch install

For example, if the Windows6.0-KB934307-x86.msu file is in the D:\934307 folder, I would use something like the following:
wusa D:\934307\Windows6.0-KB934307-x86.msu /quiet /norestart /log:D:\934307\Windows6.0-KB934307-x86.evtx

2017年5月9日 星期二

sql #temptable

http://stackoverflow.com/questions/4391442/how-to-save-select-query-results-within-temporary-table

Look at SELECT INTO 

select *
into #TempTable
from SomeTale

select *
from #TempTable
SELECT ID as 'ID',
(SELECT <....> FROM table WHERE <...> ) AS 'Total No of people'
FROM somewhere

SELECT LTRIM(RTRIM(Names)) AS Names FROM Customer

SELECT CONVERT(varchar(10), field_name) FROM table_name
LEFT(colName, 1)


firstname lastname
Bill      smith
you can do something like
select firstname + ' ' + lastname from thetable
What I use for IsNotNullOrEmptyOrWhiteSpace in T-SQL is: link
SELECT [column_name] FROM [table_name]
WHERE LEN(RTRIM(ISNULL([column_name], ''))) > 0


Code
USE AdventureWorks2012;  
GO  
SELECT   ProductNumber, Category =  
      CASE ProductLine  
         WHEN 'R' THEN 'Road'  
         WHEN 'M' THEN 'Mountain'  
         WHEN 'T' THEN 'Touring'  
         WHEN 'S' THEN 'Other sale items'  
         ELSE 'Not for sale'  
      END,  
   Name  
FROM Production.Product  
ORDER BY ProductNumber;  
GO  



UPDATE
  MyTable
SET
  MyColumn = UPPER(MyColumn)


Finial save the result

LINK from stackoverflow
Use following syntax to create new table from old table in SQL server 2008 :
Select * into new_table  from  old_table 
Adding Column in existing Table:

ALTER TABLE Tb_Table1 ADD isdone  BIT DEFAULT 0
BIT column can have two values (0 = false, 1 = true) or no value at all (NULL)


Better techniques for trimming leading zeros in SQL Server?
I've been using this for some time:

SUBSTRING(str_col, PATINDEX('%[^0]%', str_col), LEN(str_col))