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

Mar
27
comment Commercial vs Personal software licenses
I was also thinking about pointing this out for future readers, I was pretty sure the tool you wanted to use would be fine, but I have seen some messes created where people did something in a tool that the company didn't have and then left.
Feb
17
comment What are some good assignments for an introductory course, to reach today's students?
When I taught, I always used real life types of examples and they were plenty interesting to my students because they were serious about their profession. Just becasue you use business examples doesn't mean you can't start with basic techniques. It does mean that the young devs can more easily relate their knowledge to the tasks they will actaully need to do once they are employed. I am not interested in colleagues who can only work if it is fun. We don't try to make civil engineering fun or the study of medicine fun. This is serious stuff, it deserves the respect of being taught seriously.
Dec
11
comment How can I automate production deployments without experiencing extreme anxiety?
Then set up an environment that you refresh from Prod just before you run the automated script. Use it for nothing else.
Nov
22
comment Which database schema should I pick?
JOins are good, you want joins. You just need to index teh joins fields properly, databbases want and expect joins.
Nov
4
comment Advice on designing web application with a 40+ year lifetime
The data is what needs to last for over 40 years, hire a database specialist to design it. Preferabley someone with HIPAA experience. This is not easy stuff (you are likely going to need encrypting and auditing of both table changes and data changes for instance)and is critical if you are storing any kind of patient records.
Oct
8
comment Database is performing slow, even all the tables are having normalization
I would disagree, if I asked this question in an interview I would expect the interviewee to say a lot of other things before mentioning denormalization. Denormalization in an already existing database is a serious risk, I would expect the person to not suggest that as the first alternative, although I would expect given the way the question is worded that they would mention denormalization and both the pros and cons.
Oct
8
comment Database is performing slow, even all the tables are having normalization
@JeffO, Yes that is one way to fix some problems with poor performance if the problem is mainly in the reporting end of things.
Oct
8
comment Database is performing slow, even all the tables are having normalization
And check to see if all the joins are used. I have seen this espcially when people are using views that call views where lots of unneeded work was being done that would not have happened if they had written the code directly. But I have seen this in nonview code as well. And of course not selecting information you don't need (such as using select * in any query using a join).
Oct
8
comment Database is performing slow, even all the tables are having normalization
I would never suggest denormalization as the first performance fix. This is the fix of last resort as it often creates data integrity problems. And I certainly would never mention it without discussing how I would avoid data integrity problems and how denormalizing could slow inserts/updates/deletes but speed up selects. Likely proper indexing would make the normalized tables perform well without the risks of denormalizing.
Oct
7
comment How to code review without offending other developers
'The code doesn't progress until the reviewer approves it, and the reviewer won't approve it until the questions are answered." I thnk this is key. If you do code review after teh code has moved to Qa or even prod, then people will resist chaning it even more. If they know that they have to pass code review, they will be more open to making changes.
Sep
23
comment Sprint planning and accommodating slack
@KrisVanBael, in an ideal world yes. But I would wager that most people who think they are doing agile do not plan that way. Of course I would also wager that many of the organizations that think they have agile processes, don't.
Sep
11
comment Is rotating developers on a project a good or bad idea?
What I would suggest is that you make the intital team that starts the project composed of some current legacy devlopers and some current new project devlopers. Keep them through the porject. At the end the lagacy devlopers support the new product and the new devlopers join some other legacy developers to do the next project. That way the team is teh same through the project (Or major release) but legacy people get up to speed on what they will be supporting later. New hires shoudl generally start on legaacy unless they have some special skill you team doesn;t havea nd needs for the project.
Aug
14
comment Is handwriting out code an efficient way to learn a programming language?
From the perspective of someone who has taught, it was probably done to make cheating more difficult. The fact that yes people do retain knowldge better when they have hand-written it is a side benefit.
Aug
13
comment What makes C so popular in the age of OOP?
This answer is also the answer to why do we still need SQL!
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
@FlorianMargaine, BI is a programming field
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
@TravisParks, a reporting specialist should be able to write a long SQL statement (with maybe 15-20 joins and 10 where conditions) that runs fast. Never hire anyone for a role like this who is not expert in performance tuning as reporting is often where the worst of the performance issues lie. In interviewing ask them how they would replace a correlated subquery to get the code to run faster. Another good question is to ask them what they don't like about SSIS (If they say nothing, they don't know SSIS very well.) Ask them how they would scrub data.
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
Oh and real BI people who are competent get paid as much or more than developers.
Jul
30
comment Is Business Intelligence (BI) the Right Job Title?
I am a Business Intelligence specialist and if they don't know SQL at the expert level, they are incompetent pure and simple. You cannot do SSIS packages or SSRS reports effectively witrhout knowing advanced SQL. Yes you can throw something together but it is likley that it will be incorrect and the people who are relying on the reports will not know it. These people are more than incompetent, they are dangerous to the organization as real world decisions are being based data provided through their incompetence.
Jul
30
comment How to create better OO code in a relational database driven application where the database is poorly designed
This book might give you som eideas of how you can start to fix the datbase problesm and keep the legacy code working: amazon.com/…
Jul
29
comment Does dealing with legacy code help one evolve as a programmer?
@RossPatterson, since this is banking, yeah I hope they really do work correctly now. At anyrate if there are no tests, then the risk of making a change is huge in banking and writing unit tests to help you learn the system should be an easy sell.