Solved

BEST Hardware for SQL SERVER 2005 or 2008

Posted on 2008-10-28
9
627 Views
Last Modified: 2012-05-05
Hi,

I am planning to buy a NEW system and install  SQL server 2005 to learn more on DBA activities. Please suggest me, where to start from and what, like:

Which laptop : DELL, LENOVA, HP...
What O/S etc.


0
Comment
Question by:Agesh
  • 3
  • 3
9 Comments
 
LVL 14

Expert Comment

by:dfxdeimos
ID: 22826895
So you want a Laptop specifically or would you consider a desktop also?

What is your price range?
0
 

Author Comment

by:Agesh
ID: 22827262
A Laptop, I can afford around 1000 - 1500, Please recommend your thougths so that I can decide the price later.
0
 
LVL 14

Accepted Solution

by:
dfxdeimos earned 250 total points
ID: 22827316
If you are just running a test environment you don't need a TON of power. I like Sager laptops personally... they are geared more towards gamers but they are very high quality and have a TON of power.

http://www.sagernotebook.com/category_browse.php?cid=&price_s=998&price_e=1500

Lenovo also makes some nice laptops.

http://shop.lenovo.com/SEUILibrary/controller/e/web/LenovoPortal/en_US/catalog.workflow:category.details?current-catalog-id=12F0696583E04D86B9B79B0FEC01C087¤t-category-id=1BE480ADA7EB421099C1676099E3EA34

Whatever you get, order something with at least 4GB of RAM. Then you will have no problems running virtual machines inside of your PC so you can experiment till your hearts content.
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 6

Assisted Solution

by:stevepo
stevepo earned 250 total points
ID: 22832223
Look for at least 4 GB of RAM as the previous poster said and again I agree you don't need a ton of power in a test environment but for a comfortable experience you'll want at least a dual-core processor (Core 2 Duo preferrably) and also many laptops you find will come with a 5400 RPM hard disk drive.  Try to get a 7200 RPM Serial ATA drive (as opposed to IDE / ATA) if possible (it may be a little more expensive) but it will be worth it.
0
 
LVL 6

Expert Comment

by:stevepo
ID: 22832348
Sorry for the double post but I forgot to add that the OS you'll need will depend on what version of SQL 2005 you are running.  I believe SQL 2005 Enterprise will only run on Windows Server 2000 SP4 and above.  SQL 2005 Standard will run on Windows 2000 Server SP4 and above as well as XP Professional SP2. SQL 2005 Developer edition will work on Windows 2000 Pro SP4 and above and I believe SQL 2005 Express will work on any of the aforementioned OSes
0
 
LVL 14

Expert Comment

by:dfxdeimos
ID: 22833632
You are correct about the OS requirements, but if you get a powerful enough machine you can easily run Virtual Machines with something like VirtualPC, install any OS you desire on the Virtual Machine, and then keep your development / test environment seperate.
0
 
LVL 6

Expert Comment

by:stevepo
ID: 22834284
Very true, I am right behind you on using virtual machines.  The poster should do that as well, these days I always do any testing via Virtual PC as to keep my environments separate and give myself more freedom to explore the outcome of testing without worrying about messing up my primary machine / operating system.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
A short film showing how OnPage and Connectwise integration works.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now