筆電鍵盤沒有Home鍵，全選整行

fn + shift + ◀

一般Windows鍵盤是Shift + Home全選整行
但是筆電鍵盤或是60%鍵盤沒有Home鍵的替代方式
文章置頂怕忘記，因為用辦公室和家中都用桌機，常忘記

vSphere資源監控（SCOM以外的方案）

微軟SCOM以外的方案

資料來源：

網管人2025第229期 

https://www.books.com.tw/products/E060016358

免費

vCheck

https://github.com/alanrenouf/vCheck-vSphere

As Built Report

https://www.asbuiltreport.com

https://www.sexigraf.fr

https://github.com/sexibytes/sexigraf

付費

PRTG

https://www.paessler.com/prtg/prtg-network-monitor

Windows QoS 限制流量

https://woshub.com/limit-network-file-transfer-speed-windows/

需要啟用網卡的Qos Packet Scheduler

Java 8u261以上才支援SHA384WithECDSA

https://www.oracle.com/java/technologies/javase/8all-relnotes.html#R180_261

security-libs/javax.net.ssl

➜ Increase the priorities of GCM cipher suites

In TLS, a ciphersuite defines a specific set of cryptography algorithms used in a TLS connection. JSSE maintains a prioritized list of ciphersuites. In this update, GCM-based cipher suites are configured as the most preferable default cipher suites in the SunJSSE provider.

In the SunJSSE provider, the following ciphersuites are now the most preferred by default:

TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384

https://github.com/AdoptOpenJDK/openjdk-jdk8u/blob/master/jdk/src/share/classes/sun/security/ssl/CipherSuite.java

IBM DB2 11.5 clients and drivers

https://www.ibm.com/support/pages/download-initial-version-115-clients-and-drivers?mhsrc=ibmsearch_a&mhq=IBM%20Data%20Server%20Driver%20Package

需先註冊成為IBM網站會員，註冊免費
沒有特殊需求請下載IBM Data Server Driver Package (DS Driver)

以下引自官網資料

Document Information

More support for:
IBM Data Server Client Packages

Software version:
11.5

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
387577

Modified date:
04 May 2022

TSQL利用CASE WHEN處理null值

 
因為有些欄位有null值，select出的資料整筆變成NULL

 

使用CASE WHEN去處理

 

 

 

gist
https://gist.github.com/imrexhuang/3715d6087e26f77577a1b5df937bb38b#file-tsql-case-when-null

 

sqlfiddle
http://sqlfiddle.com/#!18/5eba54/10

TLS 1.2 Support for SQL Server 2008, 2008 R2, 2012 and 2014

https://docs.microsoft.com/zh-tw/archive/blogs/sqlreleaseservices/tls-1-2-support-for-sql-server-2008-2008-r2-2012-and-2014

KB3135244 - Microsoft SQL Server 的 TLS 1.2 支援
https://support.microsoft.com/zh-tw/topic/kb3135244-microsoft-sql-server-%E7%9A%84-tls-1-2-%E6%94%AF%E6%8F%B4-e4472ef8-90a9-13c1-e4d8-44aad198cdbe