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 12»»

SQL Server Training Kits...hardware/software WTF! Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 11:44 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 873, Visits: 873
I've been working with SQL Server 2005/2008 at a small software company for about six years now, having trained myself as I went along. Now I've decided to pursue certification so I can have some confidence my skills will be transferable should I decide to leave the company.

I just received my copy of the 70-462 training kit from Amazon. The first thing I read was the hardware requirements. My jaw dropped. I literally don't know anyone with the kind of loose cash lying around to shell out on that kind of hardware.

I'm hoping someone can advise me as to a relatively low(er)-cost route to obtaining the hardware I need to complete this course without taking out a home equity loan. Or am I deluding myself that someone on a modest income has any realistic path to certification?

thanks,
ron


-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown
Post #1346810
Posted Saturday, August 18, 2012 2:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 39,977, Visits: 36,340
My 4-year old laptop that cost me < $1000 when I bought it runs SQL 2008 (and 2012) just fine. If you're not planning on doing heavy database work (or are OK with it taking time), just about any reasonable modern machine (other than netbooks) can run SQL Server


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1346825
Posted Saturday, August 18, 2012 5:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 9:32 AM
Points: 44, Visits: 115
I have old desktop bought 7 years ago and it is working fine for SQL server 2008.
You can bought old machine in very less cost and start your work.
Post #1346832
Posted Saturday, August 18, 2012 11:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:24 AM
Points: 128, Visits: 490
Not sure exactly what those requirements are in the book but I have a $400 tower based server that runs SQL server 2008 r2 just fine for development purposes. My 2 year old win laptop does too.

Mark



Post #1346852
Posted Saturday, August 18, 2012 12:26 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:17 AM
Points: 31,080, Visits: 15,526
My demo VMs for SQL Server 2008 and SQL Server 2012 are set at 1MB RAM and a 40GB disk.

Works fine. Almost any laptop will run SQL Server dev edition.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1346864
Posted Saturday, August 18, 2012 12:33 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 873, Visits: 873
The hardware requirements appear to be more in support of Hyper-V than of SQL Server itself. The specific requirements in the Training Kit are:

============
Virtualization Hardware Requirements:

- x64-based processor that includes both hardware-assisted virtualization (AMD-V or Intel VT) and hardware data execution protection. (On AMD systems, the data execution protection feature is called the No Execute or NX bit. On Intel systems, this feature is called the Execute Disable or XD bit.) These features must also be enabled in the BIOS.

- 8GB of RAM

...and then a few other things that don't really contribute much.

Software Requirements:

- Windows Server 2008 R2

- SQL Server 2012

- the AdventureWorks dbs
==============

The alternative to using virtualization is to set up a network of six 64-bit PCs.

Am I making this out to be more of an investment than it is? Because this sounds pretty expensive.

ron


-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown
Post #1346870
Posted Saturday, August 18, 2012 12:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:17 AM
Points: 31,080, Visits: 15,526
If you are going to do AlwaysOn, then 5 is the recommended number of machines, but you could get by with 4 (or 4VMs).

You could go to 6 as a max. The domain controller is the one that has to be separate from the (up to) 5 SQL instances.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1346872
Posted Tuesday, August 21, 2012 9:07 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 873, Visits: 873
Looks like the least I can get away with is about a $600 machine. A second-gen i3 and 8GB of RAM should do, but I might as well go i5. In the grand scheme of things, it's a heck of a lot less than taking the training courses. So I guess I shouldn't complain.

ron


-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown
Post #1347856
Posted Tuesday, August 21, 2012 9:17 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:14 PM
Points: 39,977, Visits: 36,340
The requirements are for the Always On setup. If you're willing to skip practicing that (which does need 3-5 machines), then any old computer can run SQL Server for the rest of the stuff.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1347866
Posted Tuesday, August 21, 2012 9:26 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 873, Visits: 873
GilaMonster (8/21/2012)
The requirements are for the Always On setup. If you're willing to skip practicing that (which does need 3-5 machines), then any old computer can run SQL Server for the rest of the stuff.


Since the goal is to pass the 70-462 exam (along with 461 and 463, with an eye toward MCSA certification), is Always On something I can afford to skip?

ron


-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown
Post #1347873
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse