2017 Interview Note

坦白說我很佩服別人換個工作可以寫一篇文章, 那個申請數量跟面試量實在是有夠驚人, 大到我都很懷疑那是怎麼做到的(哪來那麼多時間去面, 是不用上班嗎?)
這半年來其實我也面了大約10幾間左右(好吧, 我今年有休假), 實際上有面對面的只有一半左右(應該不到), 而有拿到offer的也只有兩間(一間contract, 一間fulltime).
除了PR以及WebMD以外, 實際有面的公司都集中在10月中, 主要是11月開始.

面了不少公司大多卡在第一關就bye了, 這包含
Continue reading


Finally, you can save parameters in SSRS – by CiQuest Lab.


Many users are asking if there is a way to save parameters on SSRS reports. The answer is always not attractive.
Some people proposed a way to save your “last entry” in a table – well, that’s a good start, but with restrictions.
Actually, users are spending too much time on filling the criteria then viewing the report – that’s not right !

And the solution is coming, follow us and check back later~

Follow us on CiQuest Lab. @ http://www.ciquest.com

Cursor or not ?

SQL Server Cursor is a long existing function Microsoft provides. However, its performance is always being discussed (most discussion is poor performance in Cursor). If that’s the case, it’s about time to prove it and see if there is an alternative.

I have a sample table (no PK) with prepared data (180 rows). All I want is to process all the data one by one (if that’s the case). You can see below (left is cursor, right is an alternative solution).

Continue reading

Everything about Roomba

趁老婆帶兒子回台灣住的這兩個月, 我花了點時間把一樓客廳跟房間的地毯全拆了, 改鋪Laminate Wood. 這項工程耗費了兩個周末, 以及一位摯友無條件的幫忙得以完成.
(話說原屋主的地毯真的是只能用噁心來形容…)換完地板後除了整個房子看起來明亮很多(原本的地毯是深咖啡色), 而且我現在也敢躺在地上了(大心).

但是換完地板後接踵而來的就是灰塵的問題, 對此, 我上eBay買了一台New(Other)的Roomba 595, 只是那為賣家似乎並沒有很老實的告知機器有隱藏的問題讓我花了相當的時間研究問題. 也因此, Roomba 400, 500, 600, 700, 800, 900系列的差異也都搞得差不多了. 這篇先列出500以及600的差異.

Continue reading