24,819 reputation
354105
bio website
location
age
visits member for 4 years, 8 months
seen 20 hours ago

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
Apr
1
answered Is slower performance of programming languages, really, a bad thing?
Apr
1
comment What should you leave behind for your successors?
@Demizey, Maybe your source control is easier to understand than ours, but I just transitioned from ope project to another and I had to show my replacement the many different locations she should put the code depending on whether it was a one-time data fix, an import, an export, a report, a change to the application or a client customization. And when you work on a cross-functional team as I do, I have maybe 30-40 different places in source control to know about.
Apr
1
comment How can you achieve and maintain flow while pair programming?
@Giorgio, being in the zone does not require quiet or good working conditions. They make it easier, yes. But once you learn to work in the other conditions, you can tune out pretty much anything. No one, in my experience though, is in the zone 100% of the time. And being the zone is a nice to have not a requirement. I have seen people who plug away faithfully way outperform people who only work if they are in the zone which only happens rarely for them. Private offices and no noise are extremely expensive, the increased productivity doesn't justify the cost in most larger organizations.
Mar
27
comment How does understanding computer architecture help a programmer?
LOL at the thought of someone posting a Wikipedia link as an example of a rigorous definition of anything.
Mar
25
comment Can a developer perform testing efficiently?
And this does not mean they shouldn't test thier own code or write untitests. This means someone else needs to test it as well becasue the person who wrote the code knows what it does and cannot fully test what a professional tester would test. I can't tell you hpw many times our testers have found bugs because the devloper didn't fully understand the requirement. Or it bnever occurred to the devloper that a user would do that.
Mar
21
comment Why do relational databases only accept SQL queries?
To me this is like asking why don't toasters accept Ice cream.
Mar
21
comment Audit trails and recording actions
We do before and after fields and have the same structure for each audited table. That way we can also create scripts to automatically create an audit table when a table is created adn we don't have to adjust it every time the table is changed. I have to say the person doing your dba work is unknowledgable if his worry is about creating too many tables. He should be worried more about performance and blocking. As far as the number of fields, he should be thinking about what the data will be used for. Those are not unnneeded fields, they are necessary to track down where bad data came from.
Mar
20
answered Audit trails and recording actions
Mar
14
answered Do You Still Need Indexing After Database Normalization
Mar
13
answered How do I handle having so many SQL queries?
Mar
8
comment Why are software schedules so hard to define?
@Peri, Granted I wouldn't either really, but many people do forget to add time for writing tests and only think of the main problem at hand. Good for your bosses, it amazes me how many don't.
Mar
7
answered Why are software schedules so hard to define?
Mar
6
comment What are the arguments against or for putting application logic in the database layer?
@ChristopherMahan, there is a lot you can do in database design to prevent bad data.
Mar
6
comment What are the arguments against or for putting application logic in the database layer?
All database code should be in source control in any event. It is code like any other.