24,553 reputation
352104
bio website
location
age
visits member for 4 years, 6 months
seen Mar 24 at 13:13

Mar
24
revised What to do when client have unrealistic expectations?
added 3 characters in body
Mar
16
revised When should I stop programming / coding?
edited body
Feb
23
revised How do you respond to: “Ever since the update…” questions from clients?
added 956 characters in body
Feb
22
awarded  Nice Answer
Feb
18
comment Why is naming a table's Primary Key column “Id” considered bad practice?
Try writing something with 30 joins and you will see why it is an antipattern.
Jan
21
comment How to make significant technical decisions given very little time
It takes less than ten minutes to set up the structure in a spreadsheet (the most complicated part is deciding what factors you want to compare priorities on) and then it is easy peasy to fill in.
Jan
20
answered How to make significant technical decisions given very little time
Jan
9
revised SQL Triggers and when or when not to use them.
added 11 characters in body
Jan
6
comment Why is prefixing column names considered bad practice?
I never write a production query without aliasing all the columns. It makes maintenace so much easier. Of course I write complicated reporting/export type queries with up to 10-20 joins and 30-50 columns and six months later it is hard to remember which table that column came from.
Nov
12
comment What is the appropriate way to handle implicit requirements?
The implict part had to do with how we were handling exceptions and what those really should have been. The people who did it thought they were just common sense but since they introduced a bug...
Nov
12
comment What is the appropriate way to handle implicit requirements?
For the record, both performance and security should under no circumstances be implict requirements. Making them implilct is why so many systems have bad security and worse performance.
Nov
12
answered What is the appropriate way to handle implicit requirements?
Oct
23
awarded  Necromancer
Oct
8
comment Databases and Unit/Integration Testing
Again to re-iterate, you cannot unit test sql code agaist a blank database or opne with few records, you lose the meaning of the query and a query with correct syntax is irrelevant if it returns incorrect results. Ther result set is what you need to test not just the syntax. Unit testing for data is far differnt thatn application unit testing.
Oct
2
comment Databases: Where should the application logic run?
I agree that the Hybrid approach may be the best one.
Oct
2
comment Databases: Where should the application logic run?
@MatthieuM. and you may have requirements that don't allow that. And you may not even own or be allowed to change all the applications. You may need to use 3rd party applications which don't allow that.
Oct
1
comment Databases: Where should the application logic run?
No you absolutely cannot do the same thing with views. Yes you can limit what specific field can be updated through views, but with stored procedures you can specifically limit the particular actions that can be taken by a user in a much more detailed way. YOu can make them have to do multiple tasks for instance in a particular order on different tables which you can't do by managing securty through views. In a financial system, if you do not use stored procs your system is wide open for fraud.
Oct
1
comment Databases: Where should the application logic run?
Stored procs can be as subject to SQl injection as prepared statements, that is not the only security need that can be handled by stored procs. When you use prepared statements, you have to grant access at the table/view level. When you use stored procs the access can be at the stored proc level only and thus no one can do anything that is not in the proc. If you combine that with not using dynamic SQl, then it is more secure. In a financial system for instance it would be a necessary internal control to not allow anyone except the admins to do anything to the database not defined by a proc.
Sep
30
answered Databases: Where should the application logic run?
Sep
18
comment How much pair programming is ideal?
@JeffO, for an introvert, it would almost certainly be exhausting as person interactions suck energy from them and private timerenews the energy. I can see it as demanding too as it would be harder to take a few minutes break to think of something else which some people need because they tend to problem solve with their unconcious brain. Plus you have to deal with negotiating personality and and work style differences all the time. It exhausts me to even think of it.