24,116 reputation
352103
bio website
location
age
visits member for 4 years, 3 months
seen 1 hour ago

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.
Feb
27
comment Is it okay to convert dataset from stored procedure to IEnumerable
If the proc is complex, first make sure that in converting it, you get the same result. Personally I think you are foolish to consider converting a complex working proc to something else simply because you don't want to have procs. It is a waste of time and energy to do this and the likelihood you will introduce new bugs is high.
Feb
25
answered Developing on a production server
Feb
21
comment I need advice developing a sensitive data transfer/storage/encryption system
Is the FoxPro database encrypted? If it is not, then you are in legal trouble already if you are in the US. Before beginning this project please get some formal training on the requirements of HIPAA.
Feb
18
comment What is a job in programming really like?
All professions can be horrible or great. It greatly depends on who you are working for and what specifically you want concerning work conditions. That said, even the great jobs are not perfect and will never be perfect. You will have to work on projects that you don't like and with people you don't like on occasion. You will have to do some work you find less than fun. But all that is true no matter what profession you go into. The real world is not all fun and games. You need to learn the flexibility to adjust to whatever you find at work and not be unhappy because things aren't perfect.
Feb
17
awarded  Enlightened
Feb
17
awarded  Nice Answer