2019/09/04
T-SQL 語法風格
在討論 coding style 時, 有提到 T-SQL 是否也有語法風格規範?
找了幾個網路的文章, 在此列表做為記錄, 因為目前主要是使用微軟的 MSSQL, 自然也要附上 MSDN 的文章做為參考。
- [Transact-SQL 語法慣例 (Transact-SQL)](https://docs.microsoft.com/zh-tw/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql?view=sql-server-2017)
- [SQL樣式指南 · SQL Style Guide](https://www.sqlstyle.guide/zh-tw/)
2019/03/11
Command line recycle IIS Application Pool
## Use appcmd
### List application pool (find the apppool name)
```
C:\Windows\System32\inetsrv\appcmd.exe list apppool
==== the result ====
APPPOOL "DefaultAppPool" (MgdVersion:v4.0,MgdMode:Integrated,state:Started)
APPPOOL "Classic .NET AppPool" (MgdVersion:v2.0,MgdMode:Classic,state:Started)
APPPOOL ".NET v2.0 Classic" (MgdVersion:v2.0,MgdMode:Classic,state:Started)
APPPOOL ".NET v2.0" (MgdVersion:v2.0,MgdMode:Integrated,state:Started)
APPPOOL ".NET v4.5 Classic" (MgdVersion:v4.0,MgdMode:Classic,state:Started)
APPPOOL ".NET v4.5" (MgdVersion:v4.0,MgdMode:Integrated,state:Started)
```
### Recycle the application pool
```
C:\Windows\System32\inetsrv\appcmd.exe recycle apppool ".NET v2.0 Classic"
==== the result ====
".NET v2.0 Classic" successfully recycled
```
2019/03/04
幾個可以幫助新創業務的線上服務
內容取自 Producthunt
===============================
"What's a tool that changed your life?" - us to freelancers on Twitter yesterday.
Why we think this is an important question: freelancing often means unchartered territory. When you work for yourself, it's up to you to find clients, lead projects, manage payments, find insurance, get dressed every day, etc. But freelancing as a career option is on the rise — reports predict that a majority of the U.S. workforce will be freelance by 2027.
Want that life? Here are some of the apps that freelancers are currently using:
Freshbooks for getting paid
Slack for communication
Notion for an all-in-one workspace
Webflow for web design ✍
Qlearly as a tabs manager
Nuzzel for news monitoring
Unsplash for images
Things for managing tasks
Pastel for feedback and questions❓
1Password for security
AND CO for invoicing, expenses and proposals
Why we think this is an important question: freelancing often means unchartered territory. When you work for yourself, it's up to you to find clients, lead projects, manage payments, find insurance, get dressed every day, etc. But freelancing as a career option is on the rise — reports predict that a majority of the U.S. workforce will be freelance by 2027.
Want that life? Here are some of the apps that freelancers are currently using:
Freshbooks for getting paid
Slack for communication
Notion for an all-in-one workspace
Webflow for web design ✍
Qlearly as a tabs manager
Nuzzel for news monitoring
Unsplash for images
Things for managing tasks
Pastel for feedback and questions❓
1Password for security
AND CO for invoicing, expenses and proposals
Sent from Mail for Windows 10
2019/01/30
90% 症候群
在進行大規模盤點專案時, 有人跟我說 "敏捷不能解這題" "你要用 water fall" "你要列出總進度, 目前進度"
但最終結果都落入了90% 症候群, 沒有完全的結束
要記住的是:
- 把工作拆小
- 工作只有二種狀態: "完成" 跟 "尚未開始"
- 不要問 "這個工作的進度到那了?" 而是問 "我們完成這個功能了嗎?"
https://www.mountaingoatsoftware.com/blog/why-agile-teams-put-so-much-emphasis-on-being-done-each-iteration?utm_source=drip&utm_medium=email&utm_campaign=Why+Agile+Teams+Put+So+Much+Emphasis+on+Being+Done+Each+Iteration
Sent from Mail for Windows 10
2018/12/07
常用 Git Command
### Initialization
```
git clone git@bitbucket.org:jessewth/xxxxx.deployment.git
git flow init -f -d
git remote add upstream git@bitbucket.org:xxxxxi/nineyi.deployment.git
```
### Remove remote branch
```
git push origin --delete feature/develop_release feature/master_for_release
```
### Clean branch cache
```
git remote prune origin
git fetch --prune
```
reference: [Git: Remove information on branches that were deleted on origin](https://makandracards.com/makandra/6739-git-remove-information-on-branches-that-were-deleted-on-origin)
### Git tag
https://git-scm.com/book/en/v2/Git-Basics-Tagging
### 還原到未修改前的狀態
```
git reset --hard
```
### 還原到未修改前的狀態及刪除未 commit 的新檔
```
git clean -fd
```
##3 用 command line 看 git log
```
git log --oneline --decorate --all --graph
```
為了方便使用, 把上述 command 加入 alias, 命名為 git tree, 下次要用的時候, 直接打 git tree 即可
```
git config --global alias.tree "log --oneline --decorate --all --graph"
```
### 回復單一個檔案的變更
```
git checkout HEAD -- ../../ConnectionStrings.config
```
### Git log search keyword
```
git log -g --grep="vsts28270"
```
2018/12/06
2018/10/24
測試 JDBC driver on windows
## 下載 Microsoft JDBC Driver for SQL Server
```
choco install sqljdbc -y
```
or 下載 Microsoft JDBC Driver for SQL Server
## Microsoft JDBC DRIVER 7.0 for SQL Server Sample code 路徑
```
C:\Program Files\Microsoft JDBC DRIVER 7.0 for SQL Server\sqljdbc_7.0\enu\samples\connections
```
## 修改範例程式: 連接 URL 範例
```
// Create a variable for the connection string.
String connectionUrl = "jdbc:sqlserver://<server>:<port>;databaseName=AdventureWorks;user=<user>;password=<password>";
```
## Build
```
javac .\ConnectURL.java
```
## Run Test
```
java -cp "C:\Program Files\Microsoft JDBC DRIVER 7.0 for SQL Server\sqljdbc_7.0\enu\mssql-jdbc-7.0.0.jre8.jar;." ConnectURL
```
訂閱：
文章 (Atom)
-
PS C:\> Get-Host Name : ConsoleHost Version : 2.0 InstanceId : 9c0bcffb-f780-402f-b4ab-696e29a34f67 UI : System.Management.Automation....
-
一個糖果有一個糖果紙 一個糖果1元 現在商店在作促銷 3個糖果紙可以換1個糖果 請問 15元最多可以吃幾個糖果？
-
powershell c:\test\mypowershell_test.ps1 或是 powershell ./mypowershell_test.ps1 要把powershell放到排程裡,可用.bat檔把以上指令包起來即可。
Section 1. 如果重來, 我會這樣導入持續測試
什麼是持續測試?
持續測試是一個過程, 它將自動化測試放進軟體開發之中, 不斷的反覆進行, 以期儘早的業務風險的回饋。ref: 持续测试与自动化测试的区别是什么？
Automation Test 不是敏捷導入所要做的第一件事
在產品設計時就提供實例化規格
Why?
How?
讓 User 做測試
這一點是有趣的地方,提到利用金絲雀部署 -> Monitor (建立指標) -> Feedback --> Fix用原生的測試框架
測試人員的技術與 Develop 重疊, 彼此能有正向的聯結 (減少 solio)ATDD
對 Develop Team 的技術及能力要求很高, 不容易做到目標先不對準 Live Documents, 而是做好 acceptance criteria
Git Branch Flow
Git Flow 的問題是 Long-lived branches, 不利整合用 tunk branch 可以強迫團隊合併持續整合
導入樂高建構法, 寫完什麼就 commit 什麼, Feature 如果不要發, 就藏在 debug mode 裡
持續測試的週期
<–需求–|--產品設計–|--開發–|--測試–|--監控結果–|--維護–>Section 2. 從工程角度, 挖出產品風險
讓團隊了解指標的意義
- 先視覺化業務的結果 (report, dashboard 像1111一樣)
- 建立指標 (了解 dashboard 上的數字高低對系統的意義是什麼)
平常時不監控, 事情發生就無感做這些事的過程:
不要指望明星球員
- 明星球員離職對團隊影響大
- 明星球員在場, 團隊會依賴明星球員, 團隊不會成長
我想的是: 如果讓每個人都是備選的明星球員, 隨時都能補位?吃狗食
- 自己的東西自己測試
QA 角色定位是指出測試不足之處, 不是幫 Developer 寫測試 code流程導入的建議
Section 3. Agile UX
設計帶來改變
設計用來協助解決 Fuzzy Problem ===> Innovative Solutions1. Mind the Gap 全區思考, 留意間隙
有意識的留意 Gap
MVP 也要是 end to end 的體驗如何消除 Gap?
辦 Workshop 的方式
- 為什麼辦?
- 對象是誰?
- 辦了之後, 可能會有什麼問題?
辦 Workshop 要成功的關鍵在前期規劃2. Run with Brian 謀定而後動, 知止而有得
3. Close the Loop 反覆打磨, 止於至善
幾個推薦的 Process or User Group