23,922 reputation
351103
bio website
location
age
visits member for 4 years
seen Sep 10 at 14:55

Aug
13
comment What makes C so popular in the age of OOP?
This answer is also the answer to why do we still need SQL!
Aug
13
answered Safely fixing production database data
Aug
10
awarded  Nice Answer
Aug
5
revised How should I deal with problems with completed stories in agile
fixed typos and capitalization
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
@FlorianMargaine, BI is a programming field
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
@TravisParks, a reporting specialist should be able to write a long SQL statement (with maybe 15-20 joins and 10 where conditions) that runs fast. Never hire anyone for a role like this who is not expert in performance tuning as reporting is often where the worst of the performance issues lie. In interviewing ask them how they would replace a correlated subquery to get the code to run faster. Another good question is to ask them what they don't like about SSIS (If they say nothing, they don't know SSIS very well.) Ask them how they would scrub data.
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
Oh and real BI people who are competent get paid as much or more than developers.
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
I am a Business Intelligence specialist and if they don't know SQL at the expert level, they are incompetent pure and simple. You cannot do SSIS packages or SSRS reports effectively witrhout knowing advanced SQL. Yes you can throw something together but it is likley that it will be incorrect and the people who are relying on the reports will not know it. These people are more than incompetent, they are dangerous to the organization as real world decisions are being based data provided through their incompetence.
Jul
30
comment How to create better OO code in a relational database driven application where the database is poorly designed
This book might give you som eideas of how you can start to fix the datbase problesm and keep the legacy code working: amazon.com/…
Jul
29
awarded  Nice Answer
Jul
29
comment Does dealing with legacy code help one evolve as a programmer?
@RossPatterson, since this is banking, yeah I hope they really do work correctly now. At anyrate if there are no tests, then the risk of making a change is huge in banking and writing unit tests to help you learn the system should be an easy sell.
Jul
29
comment Does dealing with legacy code help one evolve as a programmer?
It also helps you to understand taht the method you think they should have used was not available when the code was written.
Jul
29
answered Does dealing with legacy code help one evolve as a programmer?
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.