IBM 支援中心：修正程式中心

http://www-933.ibm.com/support/fixcentral/

Visual Studio Community 2015 含 Update 1的ISO擋下載

https://www.microsoft.com/zh-tw/download/details.aspx?id=49988



Visual Studio 2015 ISO Files SHA-1 Values
https://www.visualstudio.com/zh-tw/downloads/visual-studio-2015-iso-sha1-vs.aspx

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.

查看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

REF:
查看JDK版本
http://it.rex.tw/2012/11/websphereibm-jdk.html






 

 

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)

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.

Seagate原廠硬碟工具軟體

http://www.seagate.com/tw/zh/support/downloads/seatools/

ref:
WD原廠硬碟工具軟體
http://it.rex.tw/2015/12/wd_27.html

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

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希捷冷資料硬碟效能大公開！

http://www.pcdiy.com.tw/webroot/article_new.php?art=1365

硬碟效能測試

為了瞭解這款硬碟效能，編輯使用了AJA System Test、Anvil〞s Storage Utilities、AS SSD、CrystalDiskMark、HD Tune、TxBENCH等6套軟體來進行測試。

BootRacer測試電腦開機速度

http://www.greatis.com/bootracer/index.html

ref:
http://www.mobile01.com/topicdetail.php?f=512&t=1814123

AJA System Test硬碟測試軟體

https://www.aja.com/en/products/aja-system-test


支援Windows、MAC

FastCopy傳檔速度測試

http://ipmsg.org/tools/fastcopy.html.en

REF:
NAS 網路硬碟傳檔，3種模式、雙重測試，誰最快？
http://www.techbang.com/posts/8976-nas-fast-or-faster

AS SSD Benchmark測試軟體

http://alex-is.de/PHP/fusion/downloads.php?cat_id=4&download_id=9

REF:
https://briian.com/9160/as-ssd-benchmark.html

Anvil's Storage Utilities SSD和硬碟測試軟體

http://www.guru3d.com/files-details/anvils-storage-utilities-download.html

REF:
http://www.coolaler.com/showthread.php/313447-%E3%80%90%E7%B3%BB%E7%B5%B1%E6%AA%A2%E6%B8%AC%E3%80%91-%E3%80%90%E7%A1%AC%E7%A2%9F%E3%80%91Anvil-s-Storage-Utilities-(1-1-0-%E7%89%88)

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

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

線上查WD硬碟保固狀態

輸入硬碟序號就可以查保固狀態
可以下載Data LifeGuard Diagnostics查硬碟序號
http://support.wdc.com/Warranty/warrantyStatus.aspx?lang=en

HWMonitor電腦硬體狀態監控工具

http://www.cpuid.com/softwares/hwmonitor.html

有免安裝版本
可以監控硬碟溫度

ref:
https://briian.com/10384/hwmonitor.html

Connect to a UNC Path with Credentials

http://www.codeproject.com/Articles/43091/Connect-to-a-UNC-Path-with-Credentials

PortQry

PortQry可以至以下網站下載

http://www.microsoft.com/en-us/download/details.aspx?id=17148

https://www.microsoft.com/en-us/download/details.aspx?id=24009　＜UI版本＞

 

 

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

Windows System Error Codes

https://msdn.microsoft.com/en-us/library/windows/desktop/ms681382(v=vs.85).aspx

Cobertura Plugin測試覆蓋率

https://wiki.jenkins-ci.org/display/JENKINS/Cobertura+Plugin

 

 

ref:
http://www.gibar.co/2014/10/jenkins-cobertura-plugin.html

Git Plugin

https://wiki.jenkins-ci.org/display/JENKINS/Git+Plugin

GitLab Plugin

https://wiki.jenkins-ci.org/display/JENKINS/GitLab+Plugin

GitBucket Plugin

https://wiki.jenkins-ci.org/display/JENKINS/GitBucket+Plugin

GitHub Pull Request Builder

https://wiki.jenkins-ci.org/display/JENKINS/GitHub+pull+request+builder+plugin

切換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

Config File Provider Plugin

https://wiki.jenkins-ci.org/display/JENKINS/Config+File+Provider+Plugin

管理設定檔



安裝後使用如下圖

 

 

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

 

CREATE DATABASE (SQL Server Transact-SQL)

https://msdn.microsoft.com/zh-tw/library/ms176061(v=sql.120).aspx

建立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

列出SQL Server資料庫所有Views

select * from sys.tables where type = 'V'

列出SQL Server資料庫所有Tables

select * from sys.tables where type = 'U'

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

Chocolatey: package manager for Windows

https://chocolatey.org

Turbo Services Manager

http://www.turboirc.com/tsm/

資料庫比對軟體Open DBDiff

http://opendbiff.codeplex.com/Wikipage?ProjectName=opendbiff

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/

方便管理的Windows工作列軟體：Bins

http://www.gadgetoflife.com/?p=5254

http://www.1upindustries.com/bins/

Windows的比對軟體

WinMerge (免費)
Beyond Compare
Araxis merge compare

計算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

SQL Join 的 WHERE 條件式位置

https://tlcheng.wordpress.com/2011/07/08/sql-join-%E7%9A%84-where-%E6%A2%9D%E4%BB%B6%E5%BC%8F%E4%BD%8D%E7%BD%AE/?hc_location=ufi

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  大檔 檔案上限

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)

Red Hat Enterprise Linux 7官方手冊

https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/index.html

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/

指令查出Windows作業系統版本

繁體(MS950)中文版WIndows:
C:\>systeminfo | findstr "作業系統"

英文版WIndows:
C:\>systeminfo | findstr /B /C:"OS Name" /C:"OS Version"

 只輸入systeminfo還會秀出所有安裝過的Hotfix

Windows 8沒有看到休眠選項

http://support2.microsoft.com/kb/2801529/zh-tw

【控制台】-> 【系統及安全性】->【電源選項】-> 【變更電源按鈕行為】