I'm a programmer with little sys admin experience. I need to order and install a server for an application that I am developing in sql server and am not sure ow to pick out the needed hardware.
Here are some of the facts of the current needs:
- The application is a vb.net app built with Visual Studio 2005. It is mainly a reporting system that inserts and queries data from SQL Server 2005. I am leveraging the SQL Server Reporting Services module for my reports.
- The dataset will eventually grow to about 1TB, over time.
- I want the server to sit on an existing small network. The user wants the system to sit off of a simple switch. We are not looking to setup a raid solution, but simply back up the data on a regular basis onto either a local disk or a remote disk (looking to keep costs low).
- There will only be a few users of this app. It would be nice if they could access the system a the same time.
- I would also like remote access to this server from home. Currently the system is connected to the internet via a cable modem to Optimum Online (Cablevision). I believe the user can already access his network online, but I'm not sure.
- As far as software in concerned, I will certainly need a copy of SQL Server 2005 and Visual Studio 2005. I'm not sure what else I will need.
- We will also be pulling in many datafiles that will be accessible either via ftp, email or webservices. This is already done today on the existing network, we will just house the data on this new server.
- I'm confused about whether I should order a souped up pc, or "server". We are planning to order the hardware from Dell. If we order a pc, I would probably stick with XP. I don't know anything about Windows Server OS.
- I was looking at a Dell Power Edge. The details of the quote are attached.
Any pointers would be greatly appreciated.