23,466 reputation
346101
bio website
location
age
visits member for 3 years, 7 months
seen Apr 15 at 21:04

Feb
13
comment How to get better at debugging?
Every outstanding troubleshooter I have met share one common characteristic. They retain information. They know where to look because they know where they have found simliar issues before or exactly which part of the application affects that particular problem or which database tables store the information and how they are populated. People who throw away information (because I can always look it up), tend to have more difficulty with debugging. Partly because by retaining information you start to see patterns in it that you won't notice if you only look up stuff.
Feb
12
answered Should Junior Programmers be involved as code reviewers in the projects of Senior Programmers?
Feb
12
awarded  Necromancer
Feb
10
answered Senior team members want to move query-relevant persistent data from DB to cache. Does this make sense?
Feb
8
awarded  Nice Answer
Feb
8
answered Criticizing your former employer in an interview
Feb
6
comment Managing SQL Stored Procedures' Version
It works pretty well (we do that here) but the key is that nothing is ever put on QA or prod unless it comes form the source control system. Since devlopers do not have the rights to deploy to other servers, their code doesn't get deployed unless they check it in.
Feb
6
comment Should experienced programmers know database queries?
@CaptainShakespeare, really it can get quite difficult once you get past CRUD operations. Ty doing complex reporting sometime. And then look at performance tuning queries.
Feb
5
comment Internationalization through SQL Database and performance issues
The developer you talked to was clearly incompetent at database design. Actually talk to professional database designers if you want to know how to make a database perform. In fact, you should hire one as the second developer you hire when desiging a data-centric application. And then actually listen to them.
Feb
5
answered Internationalization through SQL Database and performance issues
Feb
5
revised How do I deal with a slow and undedicated colleague in the team?
added 1 characters in body
Jan
25
comment Scalability: How does splitting a database table work on different replicated SQL Servers?
Define massive table.
Jan
23
comment Web Developer interview questions
@zirak, never lookup what you should be able to remember as a professional in your field.
Jan
16
comment What should my license contain for a medical-related app?
@MichaelKohne, I just wanted to point out that he is going to have to prove that he isn't collecting the data behind the scenes. And to point out that there is alot you need to know besides programming if you intend to work in a highly regulated area.
Jan
16
comment What should my license contain for a medical-related app?
And you need to be aware of the HIPAA rules concerning patient data. An app like this can get you in serious legal trouble if you don't protect patient privacy properly. If you don't know what HIPAA is and whether you are compliant, you had better not sell this app.
Jan
15
comment Pair programming when driver and observer have different skill level and experience
@ThomasOwens, I agree, I just know that many seniors get impatient with the junior driving because it takes longer than if he does it himself, so I just wanted to point this out as a possible problem.
Jan
15
comment Pair programming when driver and observer have different skill level and experience
You just have to be careful that the senior person isn't the driver 100% of the time.
Jan
10
comment What is the difference between a non-functional requirement and a quality attribute?
LOL, I have had the opposite experience of lots of functional requirements and no non-functional ones until the systemm is done and it isn't fast enough (or secure enough, etc.), BUt then our requirements are written by people on the business side.
Jan
9
comment Should database-models (conceptual or physical) be reviewed by DBAs?
Why would you think it would not be?
Jan
8
comment Database History Table / Tracking Table
You say you are only going to audit one table right now. When this changes in the future, you will want to set up a separate table fro each table audited not use one big audit table or it becomes a source of contention for resources