meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 2 years, 8 months |
| seen | 2 hours ago | |
| stats | profile views | 1,151 |
|
Feb 10 |
answered | Senior team members want to move query-relevant persistent data from DB to cache. Does this make sense? |
|
Feb 8 |
awarded | Nice Answer |
|
Feb 8 |
answered | Criticizing your former employer in an interview |
|
Feb 6 |
comment |
Learning advanced programming Odd I've run into a lot of really good programmers who went to school in India. |
|
Feb 6 |
comment |
Managing SQL Stored Procedures' Version It works pretty well (we do that here) but the key is that nothing is ever put on QA or prod unless it comes form the source control system. Since devlopers do not have the rights to deploy to other servers, their code doesn't get deployed unless they check it in. |
|
Feb 6 |
comment |
Should experienced programmers know database queries? @CaptainShakespeare, really it can get quite difficult once you get past CRUD operations. Ty doing complex reporting sometime. And then look at performance tuning queries. |
|
Feb 5 |
comment |
Internationalization through SQL Database and performance issues The developer you talked to was clearly incompetent at database design. Actually talk to professional database designers if you want to know how to make a database perform. In fact, you should hire one as the second developer you hire when desiging a data-centric application. And then actually listen to them. |
|
Feb 5 |
answered | Internationalization through SQL Database and performance issues |
|
Feb 5 |
revised |
How do I deal with a slow and undedicated colleague in the team? added 1 characters in body |
|
Jan 29 |
comment |
Penalty for making mistakes Deleting a database is worth far more than $1. If it is a production database, you should be contributing more like $1,000,000. Of course in a well-run organization, devs do not have the rights to delete databases at all even on dev servers. |
|
Jan 25 |
comment |
Scalability: How does splitting a database table work on different replicated SQL Servers? Define massive table. |
|
Jan 23 |
comment |
Web Developer interview questions @zirak, never lookup what you should be able to remember as a professional in your field. |
|
Jan 16 |
comment |
What should my license contain for a medical-related app? @MichaelKohne, I just wanted to point out that he is going to have to prove that he isn't collecting the data behind the scenes. And to point out that there is alot you need to know besides programming if you intend to work in a highly regulated area. |
|
Jan 16 |
comment |
What should my license contain for a medical-related app? And you need to be aware of the HIPAA rules concerning patient data. An app like this can get you in serious legal trouble if you don't protect patient privacy properly. If you don't know what HIPAA is and whether you are compliant, you had better not sell this app. |
|
Jan 15 |
comment |
Pair programming when driver and observer have different skill level and experience @ThomasOwens, I agree, I just know that many seniors get impatient with the junior driving because it takes longer than if he does it himself, so I just wanted to point this out as a possible problem. |
|
Jan 15 |
comment |
Pair programming when driver and observer have different skill level and experience You just have to be careful that the senior person isn't the driver 100% of the time. |
|
Jan 10 |
comment |
What is the difference between a non-functional requirement and a quality attribute? LOL, I have had the opposite experience of lots of functional requirements and no non-functional ones until the systemm is done and it isn't fast enough (or secure enough, etc.), BUt then our requirements are written by people on the business side. |
|
Jan 9 |
comment |
Should database-models (conceptual or physical) be reviewed by DBAs? Why would you think it would not be? |
|
Jan 8 |
comment |
Database History Table / Tracking Table You say you are only going to audit one table right now. When this changes in the future, you will want to set up a separate table fro each table audited not use one big audit table or it becomes a source of contention for resources |
|
Jan 4 |
comment |
Should a database table(s) structure match its intended data structure(s) in the logic? Sorry but you hit on one of my pet peeves. Too many databases are designed in a short sighted manner and with agile and ORMs it is my observation that it is getting worse and the data quality is getting worse. Databases will generally be there years after the orginal application and need to be designed for the long term. |
