23,726 reputation
347101
bio website
location
age
visits member for 3 years, 10 months
seen Jun 17 at 19:44

Apr
30
comment How do you make people accept code review?
Actually you can by not alowing them to commit code until it passes code review.
Apr
22
revised What are the arguments against or for putting application logic in the database layer?
added 2 characters in body
Apr
18
comment Storing a re-orderable list in a database
This is exactly how I handled it in a project bid preparation system we had a gazillion years ago. Even in Access, the update was likety-split fast.
Apr
17
answered How to deal with management staff (company owner) that downplays the impact of specs changes?
Apr
12
answered Are SMART goals useful for programmers?
Apr
12
comment Are SMART goals useful for programmers?
I would submit thay are not useful for pretty much any profession. Measuring what is easy or possible to measure numerically results in measuring the wrong thing generally.
Apr
11
revised Best Practices for Maintaining Uppercase vs Proper Case Data
added 929 characters in body
Apr
11
answered Best Practices for Maintaining Uppercase vs Proper Case Data
Apr
10
comment HTTP Session or Database approach
I think of this stuff because I'm the one who does the analysis of the data in the database. When designing databases, one of the first questions should be what are we going to need this data for and hardly anyone ever asks it.
Apr
10
comment HTTP Session or Database approach
You missed an advantage of database storage, abilitly of the organzation to analyze buy rates of things placed in shopping carts.
Apr
9
revised How much business logic should the database implement?
added 46 characters in body
Apr
9
comment How much business logic should the database implement?
In SQL server only poorly written sps need to be called in a loop, you can send it sets of data in a parameter and do a set-based process.
Apr
9
answered How much business logic should the database implement?
Apr
9
comment How much business logic should the database implement?
of course if that is how you test your database access, you will have lots of incorrect sql that passes the unit test but doesn't actually return the right results form the database which is the most critical part for teh devloper to test.
Apr
9
answered Is it OK to have a team with same abilities but different skill levels?
Apr
8
comment why are noSQL databases more scalable than SQL?
Of course SQL databases scale perfectly well into trillions of records, they just need some expertise to design and set them up that application developers don't have. And generally a fairly expensive set of hardware and licenses.
Apr
8
comment HTTP Session or Database approach
Remeber you need to think about order and shopping carts from the perspective of what might the business need the data for inthe future. If they want to analyze data, it is best to store it. Developers get hung up onteh user interface and forget the data's purpose in being stored when desiging.
Apr
8
comment HTTP Session or Database approach
But in the end this is a requirements definition problem and you should tell your business what you plan to do and make sure it is what they expect before you build anything.
Apr
8
comment HTTP Session or Database approach
It also helps the company analyze sales. How often is a product put in a cart but not bought. If the percentage is high, then they might want to look at how the product is presented or the price to see if changes can help imporve teh buy rate. Saving can also allow the user to see those items quickly if he didn't order tehm the day he looked rather than look for them again. So maybe you put them in your cart but wanted to wait til tomorrow (payday) to actually purchase them. So saving the data might result in your real customers buying more stuff.
Apr
8
answered User stories are too high level and conceptual, management expects developers to fill in the blanks