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

fn + shift + ◀

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

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

舊版本SQL Server 2012 Native Client和ODBC Driver 11 for SQL Server資料庫驅動程式不支援TLS 1.2

ODBC Driver for SQL Server最新版已經出到17
https://docs.microsoft.com/zh-tw/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15

SQL Server Native Client 11 (SNAC)因為已經是時代的眼淚，最新版就是QFE版
https://www.microsoft.com/en-us/download/details.aspx?id=50402

https://docs.microsoft.com/zh-tw/sharepoint/security-for-sharepoint-server/enable-tls-1-1-and-tls-1-2-support-in-sharepoint-server-2016

1.1 - 安裝 ODBC Driver 11 for SQL Server 的 TLS 1.2 支援更新

ODBC Driver 11 for SQL Server (適用於 SQL Server 的 ODBC 驅動程式 11) 預設不支援 TLS 1.1 或 TLS 1.2。您必須安裝 ODBC Driver 11 for SQL Server 的 TLS 1.2 支援更新。

• 若要安裝 ODBC Driver 11 for SQL Server 的 TLS 1.2 支援更新，請參閱＜Microsoft® ODBC Driver 11 for SQL Server® - Windows＞。

1.2 - 安裝 SQL Server 2012 Native Client 的 TLS 1.2 支援更新

SQL Server 2012 原生用戶預設不支援 TLS 1.1 或 TLS 1.2。您必須安裝 SQL Server 2012 Native Client 的 TLS 1.2 支援更新。

• 若要安裝 SQL Server 2012 Native Client 更新，請參閱＜Microsoft® SQL Server® 2012 Native Client - QFE＞。

http://net.rex.tw/2021/08/sql-server-2012-native-client-qfetls-12.html
小弟我剛好有用到SQL Server 2012 Native Client，以上這篇文章是整理的一些心得，SQL Server 2012 Native Client 需要新版的QFE版才支援TLS 1.2 

下載Microsoft® SQL Server® 2012 Native Client - QFE (支援TLS 1.2)

https://www.microsoft.com/en-us/download/details.aspx?id=50402

Version:
11.0.7001.0

Date Published:
1/19/2018

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

檢測工具(CheckClientUpdates.ps1)
https://github.com/Microsoft/tigertoolbox/tree/master/tls1.2

CheckClientUpdates.ps1
The PowerShell Script currently supports the following:

Check if SQL Server Native Client can support TLS 1.2
Check if Microsoft ODBC Driver for SQL Server can support TLS 1.2 This script is restricted to work on x64 and x86 platforms

在AP伺服器上檢測SQL Server資料庫驅動程式是否支援TLS 1.2？

支援TLS 1.2

不支援TLS 1.2

對於OLAP資料查詢或高成本的join來說，利用indexed view可以大大地提高效能

https://dotblogs.com.tw/ricochen/2009/10/04/10907

ref:
https://dotblogs.com.tw/rockchang/2016/04/26/100926

備註:
https://blog.greglow.com/2019/04/19/sql-do-indexed-views-really-require-enterprise-edition-of-sql-server/
SQL Server Enterprise/Evaluation/Developer以外版本需手動加上WITH(NOEXPAND)