Nice job Steve,
What caught my eye was the configuration of your SQL servers at your present job:
1 SQL Server 2000 production server driving our website and internal site. 2 databases, both under 1GB
2 IT SQL 2000 servers matching the production server, 1 for development, and 1 for QA. A few other misc. databases (bug tracker, release tracking, etc). All databases under a GB.
1 SQL Server 7 server hosting Goldmine CRM in one database (2GB), and Dynamics (MS, formerly Great Plains) accounting software( < 1GB).
I work for a company about the same size as yours (30 emp.). I am transitioning our company from FoxPro 2.6 and 6.0 files to an SQL server. As a beginning SQL server developer/admin, I have a couple questions:
1)Did you have all of those databases on the same box ? (I think not, but any specifics wil help)
2)How you guys like Goldmine and Dynamics ? Our small company is concidering both and is looking to me for input.