170 reputation
6
bio website spencerandbrown.com/mbb
location Nashville, TN
age 38
visits member for 3 years, 6 months
seen May 15 '13 at 20:12
I'm just some guy, you know?

Apr
25
comment Why is naming a table's Primary Key column “Id” considered bad practice?
No. In your example I would probably have a CompanyOfficer or CompanyPerson table which allows a many-to-many relationship with between Company and Person with additional information about the nature of the relationship. If I were to implement it within the Company table, I would use the column names PresidentPersonID and TreasurerPersonID to preserve the *PersonID part of the name while adding the additional descriptor. inner join Person as Presidents on Company.PresidentPersonID = Presidents.PersonID
Oct
18
comment How do I dual license?
@cyco130 if you posted your comment as an answer, I would upvote it as hard as I possibly can.
Oct
18
answered Why is naming a table's Primary Key column “Id” considered bad practice?
Oct
3
comment Why is software still released with known bugs?
Related to this is the fact that every bug fix creates the opportunity to introduce new bugs in the product which can be more serious than the original bug.
Sep
29
awarded  Commentator
Sep
29
comment How can dev teams prevent slow performance in consumer apps?
The key point here is that for most consumer applications, performance is not a feature that sells software. It's not something that looks shiny in the checklist of "Things this software does." Computer games are a shining example of this thinking. The system requirements for games has steadily increased over time, meaning that new games are slower with the same hardware you had before, because a higher framerate is not going to move that box off the shelf, but realistic environments rendered in real time with fractal detail will...
Sep
26
comment How do you share your craft with non programmers?
I am a fan of using bad analogies to explain esoteric concepts.
Sep
20
comment How do I convince my fellow devs to WANT to add comments to source code commits?
"Make them...deal with support." is the winner for me. After having supported a legacy product for a few years, I cannot bring myself to commit code without some kind of comment.
Sep
19
awarded  Critic
Sep
15
answered If the purpose of a single complicated LOC is clear, would you bother to split it on to multiple lines to make its method clear as well?
Sep
15
comment Sequel vs S-Q-L
I believe this is also related to the fact that QUEL was the name of the other prominent query language back in the dark ages of RDBMS evolution. en.wikipedia.org/wiki/QUEL_query_languages
Sep
7
answered How do you refrain from doing too much when maintaining code?
Aug
25
revised The worst anti-patterns you have came across
added 21 characters in body
Aug
25
answered The worst anti-patterns you have came across
Aug
25
revised The worst anti-patterns you have came across
added 122 characters in body
Aug
25
answered The worst anti-patterns you have came across
Aug
25
answered The worst anti-patterns you have came across
Aug
25
comment The worst anti-patterns you have came across
Not doing anything is not always the worst case scenario. Sometimes it's better to have to write it from scratch than to have code to rewrite...
Aug
25
comment The worst anti-patterns you have came across
Why do you have to bring up these buried memories? I was having such a nice day.
Aug
24
awarded  Teacher