jessewth's blog: 2019

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

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