November 5, 2008 at 2:21 pm
Hi all,
I'm in the process of building out my hardware, which will be a quad-core Intel Q9550 (2.86 GHz) using 8 GB (4 x 2GB) DDR3 DRAM which runs at 1333 MHz, on an Asus P5Q3 Deluxe WiFi-AP @n motherboard. I'll have 4 x 160GB SATA II internal hard drives, plus a blu-ray write-capable optical drive. My operating system will be Vista Ultimate x64, and my plan is to install SQL Server 2005 DE x64 as well as SQL Server 2008 DE x64. I will also have whatever version of IIS comes with Vista Ultimate, so that I can run Reporting Services. As this is a personal machine, there won't be much in the way of workload, save that necessary to teach myself how to deal with configuration, backup, security, and testing of various query techniques with randomly generated large datasets. I'll probably also use the machine for importing camcorder video via FireWire, and for running a good chess-playing program that can use multiple processors/cores.
I first of all want to be sure about exactly what having Developer Edition means in terms of connectivity to the SQL Server instances. I know that the feature set is described as being the same as Enterprise Edition, but if I can't connect to it from other machines on my home network, that would make having DE nearly useless, and I might be better off with the limitations of Express Edition. I'd really rather not have those limits, though. I'll also be installing VS 2008, but I'm not sure which way to go with it. I can spend a small chunk of change on an upgrade from my existing VS 2005 Std. Ed., or I can go with just the Express pieces for VB and Web and maybe C#. I'd appreciate hearing the pros/cons involved.
I'm also concerned about the order of installation. Once I get Vista Ultimate (with SP1) installed, I would prefer to have a nice clean installation order that causes no grief at all. If there's a best or preferred order to which version of SQL Server DE should be installed first, I'd like to hear the pros/cons there as well.
Finally, I'd like some guidance on configuration, as I'll have 4 hard drives to play with. I have no issue with partitioning same if it will help me have a configuration that will represent best practices in terms of tempdb and log file locations. Keep in mind I need locations for two SQL Server instances. Any other recommendations folks have are welcome as well. Thanks in advance for any/all assistance.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
November 7, 2008 at 8:26 am
Bump... Any help here, folks? I know that trial by fire can often be very "educational", but I prefer to take learned guidance to heart. Pretty please, with sugar on top? And no pork chops either, Jeff... ???
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply