Browse by Tags

• SQL Server

• Applying algorithms to real-life problem

  Today I encountered a real-life problem. My wife got some fresh pecan. After we cracked the pecan and took the large pieces, there are some smaller pieces of pecan and shell fragments left in the bowl. My wife asked kids to separate the pecan from the... Posted Jul 09 2012, 12:19 AM by dotneteer with | with no comments Filed under: General

• Theory and Practice of Database and Data Analysis (4) – Capturing additional information on relations

  So far in this series, I have been talking about traversing related data by navigating down the referential constraints. The physical database makes no distinction about the nature of the foreign key, whether it is parent-child relationship or another... Posted Oct 03 2011, 05:37 AM by dotneteer with | with no comments Filed under: General, SQL Server

• Build a very green Windows Server

  My old server consumes about 80W. Given my top tier electricity cost of $0.24/KWh, it costs me about $14 in electricity each month, and generates considerable noise and heat. Recently, I set out to build a greener server. I bought an Intel Atom Dual-Core... Posted Apr 13 2011, 05:49 AM by dotneteer with | with no comments Filed under: General

• Relating software refactoring to algebra factoring

  Refactoring is a fairly common word in software development. Most people in the software industry have some ideas of it. However, it was not clear to me where the term comes from and how it relates to the factor we learnt in algebra. A Bing search indicates... Posted Mar 12 2011, 09:10 PM by dotneteer with | with no comments Filed under: General