2015年12月27日 星期日
Microsoft File Checksum Integrity Verifier
https://www.microsoft.com/en-us/download/details.aspx?id=11533
The Microsoft File Checksum Integrity Verifier tool is an unsupported command line utility that computes MD5 or SHA1 cryptographic hashes for files.
The Microsoft File Checksum Integrity Verifier tool is an unsupported command line utility that computes MD5 or SHA1 cryptographic hashes for files.
查看Websphere版本
http://www-01.ibm.com/support/docview.wss?uid=swg21393876
The version info command exist on all operating systems. The location is the eWAS folder.
- For Unix and Linux:
WAS_PATH /bin/versionInfo.sh
- For Windows:
WAS_PATH \bin\versionInfo.bat
Security Bulletin: Vulnerability in SSLv3 affects IBM WebSphere Application Server (CVE-2014-3566)
http://www-01.ibm.com/support/docview.wss?uid=swg21687173
Summary
SSLv3 contains a vulnerability that has been referred to as the Padding Oracle On Downgraded Legacy Encryption (POODLE) attack. SSLv3 is enabled by default in IBM WebSphere Application Server. These fixes will disable SSLv3 completely.
Vulnerability Details
CVE ID: CVE-2014-3566
DESCRIPTION: IBM WebSphere Application could allow a remote attacker to obtain sensitive information, caused by a design error when using the SSLv3 protocol. A remote user with the ability to conduct a man-in-the-middle attack could exploit this vulnerability via a POODLE (Padding Oracle On Downgraded Legacy Encryption) attack to decrypt SSL sessions and access the plaintext of encrypted connections.
CVSS Base Score: 4.3
CVSS Temporal Score: See http://xforce.iss.net/xforce/xfdb/97013 for the current score
CVSS Environmental Score*: Undefined
CVSS Vector: (AV:N/AC:M/Au:N/C:P/I:N/A:N)
DESCRIPTION: IBM WebSphere Application could allow a remote attacker to obtain sensitive information, caused by a design error when using the SSLv3 protocol. A remote user with the ability to conduct a man-in-the-middle attack could exploit this vulnerability via a POODLE (Padding Oracle On Downgraded Legacy Encryption) attack to decrypt SSL sessions and access the plaintext of encrypted connections.
CVSS Base Score: 4.3
CVSS Temporal Score: See http://xforce.iss.net/xforce/xfdb/97013 for the current score
CVSS Environmental Score*: Undefined
CVSS Vector: (AV:N/AC:M/Au:N/C:P/I:N/A:N)
Affected Products and Versions
This vulnerability affects all versions and releases of IBM WebSphere Application Server, IBM WebSphere Application Server Full Profile, IBM WebSphere Application Server Liberty Profile and IBM WebSphere Application Server Hypervisor Edition.
ATTO Disk Benchmark硬碟測試軟體
https://www.attotech.com/disk-benchmark
Test Hard Drives, SSD Drives, HBAs, RAID Adapters & Storage Controllers
輸入自己的email,會寄下載網址給你
ref:
https://briian.com/28304/atto-disk-benchmark.html
Test Hard Drives, SSD Drives, HBAs, RAID Adapters & Storage Controllers
輸入自己的email,會寄下載網址給你
ref:
https://briian.com/28304/atto-disk-benchmark.html
TxBENCH (SSD 速度測試)
http://www.texim.jp/txbenchus.html
ref:
http://www.xfastest.com/plugin.php?id=mini_download:index&mod=view&itemid=424
Seagate Archive HDD v2 8TB開箱實測,ST8000AS0002希捷冷資料硬碟效能大公開!
ref:
http://www.xfastest.com/plugin.php?id=mini_download:index&mod=view&itemid=424
Seagate Archive HDD v2 8TB開箱實測,ST8000AS0002希捷冷資料硬碟效能大公開!
硬碟效能測試
為了瞭解這款硬碟效能,編輯使用了AJA System Test、Anvil〞s Storage Utilities、AS SSD、CrystalDiskMark、HD Tune、TxBENCH等6套軟體來進行測試。
FastCopy傳檔速度測試
http://ipmsg.org/tools/fastcopy.html.en
REF:
NAS 網路硬碟傳檔,3種模式、雙重測試,誰最快?
http://www.techbang.com/posts/8976-nas-fast-or-faster
REF:
NAS 網路硬碟傳檔,3種模式、雙重測試,誰最快?
http://www.techbang.com/posts/8976-nas-fast-or-faster
WD原廠硬碟工具軟體
http://support.wdc.com/downloads.aspx
可以查硬碟序號、低階格式化、修壞軌、write zeros (full erase,硬碟賣掉前必做,很花時間)
ref:
How to low level format or write zeros (full erase) to a WD hard drive or Solid State drive
http://support.wdc.com/KnowledgeBase/answer.aspx?ID=1211
如何利用WD提供的Data Lifeguard Diagnostics程式來檢測WD硬碟?
http://www.synnex.com.tw/asp/fae_qaDetail.asp?group=&parent=&seqno=21180
Seagate原廠硬碟工具軟體
http://it.rex.tw/2015/12/seagate.html
可以查硬碟序號、低階格式化、修壞軌、write zeros (full erase,硬碟賣掉前必做,很花時間)
ref:
How to low level format or write zeros (full erase) to a WD hard drive or Solid State drive
http://support.wdc.com/KnowledgeBase/answer.aspx?ID=1211
如何利用WD提供的Data Lifeguard Diagnostics程式來檢測WD硬碟?
http://www.synnex.com.tw/asp/fae_qaDetail.asp?group=&parent=&seqno=21180
Seagate原廠硬碟工具軟體
http://it.rex.tw/2015/12/seagate.html
Windows Server 2012 Wsus 4.0 換Port
把WSUS預設的8530 port改成80 port
到C:\Program Files\Update Services\Tools\
執行Wsusutil usecustomwebsite false
REF:
http://blog.pmail.idv.tw/?p=7158
到C:\Program Files\Update Services\Tools\
執行Wsusutil usecustomwebsite false
REF:
http://blog.pmail.idv.tw/?p=7158
線上查WD硬碟保固狀態
輸入硬碟序號就可以查保固狀態
可以下載Data LifeGuard Diagnostics查硬碟序號
http://support.wdc.com/Warranty/warrantyStatus.aspx?lang=en
可以下載Data LifeGuard Diagnostics查硬碟序號
http://support.wdc.com/Warranty/warrantyStatus.aspx?lang=en
2015年12月17日 星期四
PortQry
PortQry可以至以下網站下載
PortQry使用方式
PortQry.exe -n GOOGLE.com -p tcp -o 443,80
PortQry使用方式(寫log)
PortQry.exe -n GOOGLE.com -p tcp -o 443,80 -l RESULT.log
2015年11月1日 星期日
切換Jenkins網頁介面語系
個別使用者可以使用Chrome :Quick Language Switcher
https://chrome.google.com/webstore/detail/quick-language-switcher/pmjbhfmaphnpbehdanbjphdcniaelfie/related?hl=en-US
全部使用者都切換語系
https://wiki.jenkins-ci.org/display/JENKINS/Locale+Plugin
ref:
https://wiki.jenkins-ci.org/display/JENKINS/How+to+view+Jenkins+in+your+language
https://chrome.google.com/webstore/detail/quick-language-switcher/pmjbhfmaphnpbehdanbjphdcniaelfie/related?hl=en-US
全部使用者都切換語系
https://wiki.jenkins-ci.org/display/JENKINS/Locale+Plugin
ref:
https://wiki.jenkins-ci.org/display/JENKINS/How+to+view+Jenkins+in+your+language
Jenkins Publish Over XXX Plugin
搜尋 publish over
Publish Over SSH
https://wiki.jenkins-ci.org/display/JENKINS/Publish+Over+SSH+Plugin
Publish Over CIFS Plugin
https://wiki.jenkins-ci.org/display/JENKINS/Publish+Over+CIFS+Plugin
Publish Over FTP
https://wiki.jenkins-ci.org/display/JENKINS/Publish+Over+FTP+Plugin
Publish Over Dropbox
https://wiki.jenkins-ci.org/display/JENKINS/Publish+over+Dropbox+Plugin
2015年10月30日 星期五
2015年10月29日 星期四
建立TRUNCATE TABLE的Stored procedure
--建立Stored procedure
CREATE PROCEDURE [dbo].[mysp_truncate] @tableName varchar(50)
with execute as owner
AS
DECLARE @SQL VARCHAR(2000)
SET @SQL='TRUNCATE TABLE dbo.' + @tableName
EXEC (@SQL);
GO
--授予執行權限
--這樣就算使用者沒有ALTER權限也可以TRUNCATE TABLE
--ldf檔才不會一直增加(寫入transaction log)
grant execute on [dbo].[mysp_truncate] to 資料庫使用者;
GO
--執行Stored procedure
exec mysp_truncate 表格名稱;
出處:
Creating a Stored Procedure to Truncate a Table
TRUNCATE TABLE (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms177570.aspx
Permissions
The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable. However, you can incorporate the TRUNCATE TABLE statement within a module, such as a stored procedure, and grant appropriate permissions to the module using the EXECUTE AS clause.
ref:
EXECUTE AS 子句 (Transact-SQL)
https://msdn.microsoft.com/zh-tw/library/ms188354(v=sql.120).aspx
sqlcmd 執行sql檔
sqlcmd -S 資料庫位址 -d 資料庫名稱 -i CUSTOMERS.sql > log\CUSTOMERS.log
ref:
https://msdn.microsoft.com/zh-tw/library/ms180944(v=sql.120).aspx
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
ref:
https://msdn.microsoft.com/zh-tw/library/ms180944(v=sql.120).aspx
https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-2017
2015年10月23日 星期五
Select count(*) from multiple tables
http://stackoverflow.com/ questions/606234/select-count- from-multiple-tables
橫的
with t1_count as (select count(*) c1 from t1),
t2_count as (select count(*) c2 from t2)
select c1,
c2
from t1_count,
t2_count
/
select c1,
c2
from (select count(*) c1 from t1) t1_count,
(select count(*) c2 from t2) t2_count
/
直的
SELECT 'TAB1' AS TABLE_NAME, COUNT(*) FROM TAB1
UNION ALL SELECT 'TAB2' AS TABLE_NAME, COUNT(*) FROM TAB2
UNION ALL SELECT 'TAB3' AS TABLE_NAME, COUNT(*) FROM TAB3
UNION ALL SELECT 'TAB4' AS TABLE_NAME, COUNT(*) FROM TAB4
2015年10月9日 星期五
Toolwiz Time Freeze系統還原軟體
http://www.techbang.com/posts/19270-infinite-regeneration-windows-81-boot-restore-cheat-secretly-reported-74-special-feature
由於Time Freeze 2014尚未支援保護非系統磁碟機,因而我們僅需自動排除「C:」槽中的目錄
官網
http://www.toolwiz.com/products/toolwiz-time-freeze/
由於Time Freeze 2014尚未支援保護非系統磁碟機,因而我們僅需自動排除「C:」槽中的目錄
官網
http://www.toolwiz.com/products/toolwiz-time-freeze/
2015年10月7日 星期三
2015年9月22日 星期二
2015年5月30日 星期六
計算TABLE有幾個欄位COLUMNS
https://social.msdn.microsoft.com/Forums/en-US/f73e50b1-c95d-4389-b637-47ef73505f10/how-to-count-columns-in-a-table?forum=transactsql
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COUNT(COLUMN_NAME ) ColCount
FROM INFORMATION_SCHEMA.COLUMNS
GROUP BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME;
新版本:
http://it.rex.tw/2017/11/columns.html
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COUNT(COLUMN_NAME ) ColCount
FROM INFORMATION_SCHEMA.COLUMNS
GROUP BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME
ORDER BY TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME;
新版本:
http://it.rex.tw/2017/11/columns.html
2015年5月6日 星期三
2015年3月1日 星期日
ownCloud單檔上傳上限
Dealing with Big File Uploads
https://doc.owncloud.org/server/6.0/admin_manual/configuration/configuring_big_file_upload.html
ref:
ownCloud修改上傳檔案大小上限 / Change ownCloud Upload File Max Size
http://pulipuli.blogspot.tw/2014/08/owncloud-change-owncloud-upload-file.html
ownCloud結合SFTP規劃 / Integrate SFTP to ownCloud
http://pulipuli.blogspot.tw/2014/07/owncloudsftp-combine-sftp-in-owncloud.html
tag:
upload_max_filesize 大檔 檔案上限
https://doc.owncloud.org/server/6.0/admin_manual/configuration/configuring_big_file_upload.html
ref:
ownCloud修改上傳檔案大小上限 / Change ownCloud Upload File Max Size
http://pulipuli.blogspot.tw/2014/08/owncloud-change-owncloud-upload-file.html
ownCloud結合SFTP規劃 / Integrate SFTP to ownCloud
http://pulipuli.blogspot.tw/2014/07/owncloudsftp-combine-sftp-in-owncloud.html
tag:
upload_max_filesize 大檔 檔案上限
ownCloud預設的user files存放路徑
https://doc.owncloud.org/server/7.0/admin_manual/configuration/config_sample_php_parameters.html
'datadirectory' => '/var/www/owncloud/data',
Where user files are stored; this defaults to
data/
in the ownCloud directory. The SQLite database is also stored here, when you use SQLite. (SQLite is available only in ownCloud Community Edition)CentOS 7安裝使用自動配置分頁(Automatically configure partitioning)選項home會很大
[root@localhost ~]# df -BG
檔案系統 1G-區段 已用 可用 已用% 掛載點
/dev/mapper/centos-root 50G 4G 47G 8% /
devtmpfs 2G 0G 2G 0% /dev
tmpfs 2G 1G 2G 1% /dev/shm
tmpfs 2G 1G 2G 1% /run
tmpfs 2G 0G 2G 0% /sys/fs/cgroup
/dev/mapper/centos-home 458G 1G 458G 1% /home
/dev/sda1 1G 1G 1G 24% /boot
ref:
Recommended Partitioning Scheme
https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Installation_Guide/s2-diskpartrecommend-x86.html
The ultimate guide: Owncloud 8 on CentOS 7.x – step by step. Will work 100%
http://reviews.myhken.com/the-ultimate-guide-owncloud-on-centos-7/
檔案系統 1G-區段 已用 可用 已用% 掛載點
/dev/mapper/centos-root 50G 4G 47G 8% /
devtmpfs 2G 0G 2G 0% /dev
tmpfs 2G 1G 2G 1% /dev/shm
tmpfs 2G 1G 2G 1% /run
tmpfs 2G 0G 2G 0% /sys/fs/cgroup
/dev/mapper/centos-home 458G 1G 458G 1% /home
/dev/sda1 1G 1G 1G 24% /boot
ref:
Recommended Partitioning Scheme
https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Installation_Guide/s2-diskpartrecommend-x86.html
The ultimate guide: Owncloud 8 on CentOS 7.x – step by step. Will work 100%
http://reviews.myhken.com/the-ultimate-guide-owncloud-on-centos-7/
2015年1月25日 星期日
指令查出Windows作業系統版本
繁體(MS950)中文版WIndows:
C:\>systeminfo | findstr "作業系統"
英文版WIndows:
C:\>systeminfo | findstr /B /C:"OS Name" /C:"OS Version"
只輸入systeminfo還會秀出所有安裝過的Hotfix
C:\>systeminfo | findstr "作業系統"
英文版WIndows:
C:\>systeminfo | findstr /B /C:"OS Name" /C:"OS Version"
只輸入systeminfo還會秀出所有安裝過的Hotfix
訂閱:
文章 (Atom)