Reputation
25,030
Next tag badge:
84/100 score
18/20 answers
Badges
3 55 107
Newest
 Nice Answer
Impact
~944k people reached

Jul
22
comment Getting related foreign keys from parent entities
If you do denormalize, you need to maintain the client_id through triggers on all the relevant tables. It is the only way to ensure consistency no matter how the data is changed. (There is an exception for bulk inserts which can avoid triggers but peopel doing this type of thing generally know to reproduce the trigger code they are avoiding after inserting or updating the ten million records.)
Jul
19
revised How to represent days and time graphically for a project I have done
fixed spelling error
Jul
18
answered Good Practice : Storing variables and classes names in database for direct call
Jul
9
answered Is there value denoting a key as “Primary”?
Jul
8
comment What are some possible interactions between multiple bugs?
I would add that sometimes a particular bug may result from a poor understanding of a type of code and that poor understanding may be elsewhere. I'm thinking of things like failing to handle the case where a divisor turns out to be zero or someone who never handles nulls correctly. Each implementation may be a different formula or unrelated piece of code but the same fundamental misunderstanding of what to do is through the application. Sort of like Entropy sprinkler only the code isn't necessarily related except through the coder's misunderstanding of how things work.
Jul
5
awarded  Guru
Jun
26
comment Should we persist with an employee still writing bad code after many years?
I suspect this guy woud be absolutely flabbergasted to find out that his manager is thinking of firing him. Some people you just have to hit over the head with a plank and flat out tell them that they have to improve or they will be fired.
Jun
5
comment Stored Procedures a bad practice at one of worlds largest IT software consulting firms?
@MichaelKohne, I would say never in my experience. It depends on what segment of the industry you are in. In Enterpise systems it is rare to change database vendors. In the COTS world, it happens all the time or the design must account for multiple vendor possibilities. In the web world is somehwat divided depending on what the web site actually does and how critical the db is to the success of the site.
Jun
4
answered Automatically observing changes in database tables
Jun
4
comment Automatically observing changes in database tables
If the database is Access, that database better not be large.
Jun
3
comment Requirements Analysis Communication
That would be a poor requirment. What about numbers that are appropriately stored as string data (say phone numbers) do you really want to convert them to a numeric so you can order them? Why would you sort dates by time only? Do you want 01/01/2013 22:00 to come after 06/03/2013 08:00?
Jun
1
awarded  Nice Answer
May
30
comment How to deal with the developers refusing to use certain technologies or tools?
@cHao, every job I ever had included the phrase "other duties as assigned" as part of my job description. You don't get to pick only the stuff you want to do. If it becomes more than occasional, you can choose to leave, but while they are payingyou, you do what you are asked to do. It is their money so their option.
May
29
awarded  Nice Answer
May
26
awarded  Nice Answer
May
24
comment How to salvage a business model from a mismatched database?
This is a good book to read if you are refactoring a legacy db: amazon.com/…
May
23
answered Increasing User Changes/Requirements in Agile Methodology
May
23
comment Increasing User Changes/Requirements in Agile Methodology
Isn't this the problem with waterfall that Agile was supposed to fix?
May
21
revised Is it advisable to ask employees to create 'work' GitHub accounts?
fixed incorrect workd choice
May
16
comment Enterprise application with lots of SQL queries
And if you use a SQL Server backend, you can also make the queries into stored procs.