I am looking at purchasing a new computer within the next few months, for use in work applications. I am an IT project manager (read groupie for programmers/DBAs/engineers), and have multiple clients with different needs. I need to be able to compile with Visual Studio 2015, maintain like 40 browser tabs across multiple instances simultaneously, run multiple instances of Excel, Access, and SQL Server each at once (Office 365/2016), Outlook, Project, Remote Desktop Connection, sandbox MS IIS, and similar productivity stuff. I will need to stick with Windows 10.
Currently, I just use the HDMI port to output to an LCD TV. I would probably continue that practice, but I assume VGA and DVI cords would work just as well on this and similar screens. I only use one screen right now, but I really should have multiple video output ports for future use. I also use a cheap USB wireless mouse/keyboard. I have a preference for 1) maintaining wireless, and 2) not paying for another mouse/keyboard. I seldom (3-4x/month) use USB, and doubt I would use more than 1 (besides my mouse/keyboard) at a time. I would like to have a CD-ROM (writable) drive, partially because I miss my cup holder, but I also get CDs about 5x/year.
I would like to have the option to be able to run additional OSs in order to replicate user environments at some point, and a virtual environment would be useful for other reasons. Neither would be common occurrences.
I plan to pay my ISP (once I am set up) to allow me to log into this machine remotely with one of my laptops, so I can still use it for processing and file serving while on site at a client. I am not a networking guy, and SE will undoubtedly be helping me to get that set up. I care little for the actual display quality during such a setup, but I will need to be able to open multiple very large (150x1,000,000) size spreadsheets, and do sort/filter on that data, displaying the result through remote desktop to my laptop. Probably nothing more intensive during the remote connection.
Building the computer myself would be cool, but that is about where the benefit for that (probably) ends. I remember installing a second 5.25 floppy drive on my first computer, and later an entire 20MB HD in the same computer (there was no one cooler than me in the whole world, at that point), but that is about where my building skills peaked. I soldered my brother's Playstation, installed multiple 4MB RAM sticks, and even took apart the power supply once. Now a days, I should be considered a novice at best in hardware matters. But, my wife's brother has a friend who knows a guy who says he could probably build a computer, so there you go.
This will definitely 100% be a business expense. That said, it might be nice to know I could do some leisure stuff, in case I ever get my work caught up. The most advanced game I have ever played is Civilization 4, and I can't imagine getting much more advanced than Civ6 within the next 4 years, and would probably be content sticking with Civ4, low graphics settings (I like what I like).
I don't really need to worry about any more expansion capability beyond what I have already mentioned. If my business is doing so well that I need to upgrade in less than 5 years, I can afford to buy another machine.
So, knowing that I need to purchase a Windows10 Pro license, are their any scenarios where buying the pieces and putting it together myself would be cheaper? (I doubt it)
Do different manufacturers have different track records, at the amount of computing power I will be doing (not much)?
I don't need to consider any special cooling, right?
And most importantly, what is the cheapest way to get a box that can fulfill those requirements?