Discussion on Development in Several Different Flavours
Archive for October, 2006
Thinking about database schemas
01940 days
by Adam
in miscellaneous
I’ve worked with databases on average about four days a week for the last two years. My experience with databases includes: taking over maintenance, creating from scratch, incrementally improving and even completely redesigning a few. The experience has given me a lot of practice when it comes to design choices but not enough to truly be called a “Database Manager”. It takes a lot of knowledge and experience to know exactly where to put an index to maximize performance or how best to structure your tables to minimize the need for join queries. I recently read some great articles about how best to implement “tags” structurally and I thought I would share them. (more…)
Error Handling Correction
01943 days
by Adam
in miscellaneous
Today I realized a huge problem with the global.asax error handling method that I provided in my last entry. The problem is that if you ever run into compilation errors you are left completely in the dark as to what page it came from. You just have the date, logged in user and ip address which isn’t very helpful. (more…)
ASP.Net Error Logging
41948 days
by Adam
in miscellaneous
Like any good ASP.Net developer I have Scott Guthrie’s blog bookmarked in my GReader. Recently I was browsing through the archives and came across an entry about not using Debug=”True” in production applications. I have to admit that I am VERY guilty of this since pretty much all of my applications are production and are using Debug=”True”. The reason for this is simple, I am just me and I have to monitor/update all of these applications. I do as much testing as I can before sending it off to production and moving on to the next project but often once the users start working with it something bad happens. The ability to have the errors logged including the line number in the source code is invaluable when going back to an application to fix a bug after a length of time. However, in light of Scott’s points it stops now. (more…)