30,869 reputation
240108
bio website none
location
age
visits member for 4 years, 3 months
seen 2 days ago

Nov
6
comment offline application development for mobile devices
HTML5 and javascript can be used to store to a local database on a mobile device, so I'm guessing many other technologies could as well.
Nov
5
comment Would it make sense to have a database table with only one record for tracking site summary stats?
You may want to consider who needs to see these totals, how frequent they need to be updated. If you updated your aggregate every 100 transactions, would it really make that big of a deal?
Nov
5
comment Order by different Enum property each row
You've provided plenty of information for someone to come up with a solution, but you should also make an attempt at it yourself and share the code.
Nov
1
answered Separation of retrieving data and business objects between DAL and BLL Layers
Nov
1
answered Can a table be both Fact and Dimension
Oct
29
comment What activities, outside of writing code, have been shown to improve one skill as a programmer?
What's the point? Are these other activities more accessible? Is there some reason why anyone who wants to get better at programming should want to do something else? Boxers punch bags because they can't punch each other all day long.
Oct
29
comment How do you learn a language without actual tools?
@whatsisname - Well they had today's tooling and over a hundred developers and couldn't get a government healthcare website built right the first time. I've programmed billing apps; it's no moonshot.
Oct
29
comment Improving the speed of coding in Fortran
When you say you spend too much time coding, do you mean the entire process or just the typing part? Having less to type may not give you a significant reduction of time. Limiting comments is a good thing, but less typing is probably the lease benefit.
Oct
28
comment N-Layer architecture
Yes, DAL. Sorry
Oct
27
comment N-Layer architecture
I wouldn't expect to go into the DLL and see it reference anything in the BLL.
Oct
26
comment How do you learn a language without actual tools?
@whatsisname - They sent a man to the moon 45 years ago with less processing power than a modern phone. I think they could have figured-out how to build a beer app.
Oct
26
comment Eliminating choices of programming languages?
Paintings are made by artists, not brushes.
Oct
26
comment Where is it implied that REST is not based on HTTP
What's the difference between finding it on a search or having someone else tell you they read it? Other than it's much easier.
Oct
24
comment 500 databases or 1 database with 500 tables or just 1 table with all the records?
" data that absolutely must not leak - number 3 is out of the question." I'm guessing there are thousands of websites managing different user/client data that requires a high-level of security and they put related data in the same table. I don't see my bank having a table created when I opened an account.
Oct
22
comment database migration with data already in the database in production
Can you use a default value and handle it in your program? You may need to go out of your way to prompt the user to update these values.
Oct
22
comment Efficient database access for related data
How do you avoid duplicate items when you have an individual query for each content item? Seems like a query with these two tables joined would return the same amount of results, just all at once. Maybe you need to look into paging your results.
Oct
22
comment Design Logging (or: notify) architecture in application
You'll get more help if you make an attempt and provide the classes yourself.
Oct
22
comment Stored procedure in asp.net webforms
-1 You googled .net three tier architecture and got nothing? I found 138,000 results. Many were tutorials on how to do it.
Oct
17
comment Who first used the phrase “Those who only live by the GUI, will die by the GUI”
Whoever had to debug some very ugly SQL code written with a GUI.
Oct
16
comment FizzBuzz can't be a good interview question!
At least it is a way to demonstrate you can code something.