Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

My first proper server... Expand / Collapse
Author
Message
Posted Thursday, November 14, 2013 6:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 1:15 AM
Points: 1, Visits: 7
Hi,
I'm looking to improve my Windows Server know how by getting my own server at home and installing SQL Server upon it.
I've been in the SQL and BI (Microsoft largely) game for a number of years now, and want to have my own "no consequences" environment so I can get more into Windows Server and the environment as a whole, as well as SQL Server which I use on a daily basis.

So.... I was hoping someone could help me out by suggesting what it is I need from a piece of second hand used hardware that will be able to run a minimum of Windows Server 2008 (or higher) and SQL Server 2008 and SQL Server 2012 (Enterprize Ed.).
I want to go down the used server route (Dell, HP etc.) probably bought from the web, and don't mind buying a few drives if it comes without (as they often do). My budget for the box/rack is around £200 ($320) which seems achievable from what I've seen on online auction sites.

Can anyone suggest a model that will meet my requirements please ?

This may sound like a real newcomers question, but I don't want to sink cash into something that won't do the job...

Many thanks, in advance. Lee.
Post #1514243
Posted Thursday, November 14, 2013 4:58 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:52 PM
Points: 235, Visits: 1,174
On the cheap I'd suggest running any old multicore desktop with a big usb hub that you can present as various drives, with as much cheap ram as you can cram into it, so you can practice setting up a domain with several machines.


Run everything on a VM so you can blow it up without consequence.
https://www.virtualbox.org/

Server 2012 evaluation edition which is good for 180 days.
http://technet.microsoft.com/en-us/library/jj574204.aspx


SQL Server 2012 developer edition which should be under $100.
Post #1514534
Posted Wednesday, April 02, 2014 3:45 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:38 AM
Points: 200, Visits: 1,277
benjamin.reyes (11/14/2013)
On the cheap I'd suggest running any old multicore desktop with a big usb hub that you can present as various drives, with as much cheap ram as you can cram into it, so you can practice setting up a domain with several machines.


Run everything on a VM so you can blow it up without consequence.
https://www.virtualbox.org/

Server 2012 evaluation edition which is good for 180 days.
http://technet.microsoft.com/en-us/library/jj574204.aspx


SQL Server 2012 developer edition which should be under $100.


Agree with Benjamin, here...though I have a DELL R910 and a shed-load of RAM and Storage ...and being able to create a virtual network domain and play around with VMs of all types, DCs, SQL, SSRS, SSAS, Sharepoint, IIS is fantastic, as I can create snapshots, play around - and possibly screw things up in the process - and then restore back to the snapshot to do it all again.

Edit: do'h ...got caught with this being an 'old' thread. My excuse is that I've never ventured into this part of the forum before, the parts I usually view are much more active, and from what I'm seeing I don't think many others do either.
Post #1557386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse