2,435 reputation
519
bio website
location Longmeadow, MA
age 44
visits member for 3 years
seen 17 hours ago

Just your average code monkey.

I try to keep up with technology and best practices to continually improve myself to become a better programmer.


1d
comment Returning results of method on batch list?
Your asking to keep track of the successes and failures, so yes, both type of objects are returned. If one is processing a batch, certainly knowing what items succeeded and/or failed would be important.
2d
answered Returning results of method on batch list?
Jun
23
awarded  Yearling
Jun
20
comment How would you know if you've written readable and easily maintainable code?
This should be the answer. Measure. Other answers are more opinion than fact, if I can understand it, it must good? First measure using complexity analysis, then human refactor to look for duplication, etc.
Mar
11
comment How do I stop designing and start architecting this project as suggested by my lead?
The architect wears no hat, but rather envisions an abstract head protection system.
Mar
5
comment SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Your designing the system to handle the edge case. Proper datasizing is critical for indexing. There is overhead for using this type of field. dba.stackexchange.com/questions/47910/…
Mar
5
answered SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Feb
4
awarded  Nice Answer
Jan
30
comment Why should passwords be encrypted if they are being stored in a secure database?
Disgrunted DBA says... select * from user, and then sells that list for severence pay. Nothing is ever secure.
Jan
29
answered What are the valid test cases for method calls within if-else condition
Jan
23
revised How to Explain Coding is not just Copy and Paste to non Software Developers?
deleted 2 characters in body
Jan
23
answered How to Explain Coding is not just Copy and Paste to non Software Developers?
Jan
21
comment Is CSV a good alternative to XML and JSON?
Any CSV message structure can be mapped to an XML or JSON message format. Not all XML/JSON message format can be mapped to CSV. So, CSV only covers a specific data use case, tabular format, where as JSON and XML can cover more complex message structures.
Jan
10
answered Violating SQL principles
Jan
10
comment Lead developer unable to do INNER JOIN
Your design has 5 tables and 4 relations, but you could have a design with just one table with customer, phone, and address columns on one row. Every new customer new address or phone is a new record. One table, no joins. Now there would be a lot of nulls and lots of chances to insert poor quality data and potentially data repeats, but it's a workable. So, I wouldn't call it crucial in small applications, but it's definately important and leads to better (maintainable and sound) software and underlying code.
Jan
9
revised Cascading “Deleted” records that aren't really deleted
added 1 characters in body
Jan
9
comment Cascading “Deleted” records that aren't really deleted
@MichealIT - There is no data integrity here because it is simply updating a column. You are correct the update could go in a trigger, but explicitly defining it with a delete operation (SP) would make it easier to find. In the trigger one would have to interrogate the Delete flag and take appropriate action on whether it was a 1 or 0. Trigger logic tends to be more obscure as opposed to a stored procedure.
Jan
9
answered Cascading “Deleted” records that aren't really deleted
Jan
9
revised Best way of validating Class properties
added 3 characters in body
Jan
9
answered Best way of validating Class properties