Solved

BEST Hardware for SQL SERVER 2005 or 2008

Posted on 2008-10-28
9
648 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

830 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