I'm rewriting our inventory db (Access, ASP & VBScript) using SQL Server, ASP.NET & VB.NET. I'm currently defining the specs for it (we have a really good idea of changes we want to make), but I've never done an inventory setup. I'm looking for resources (books, magazine articles, algorithms, etc.) to avoid stupid mistakes, bad decisions, etc. (as much as possible).
Could anyone recommend such resources?