Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server Training Kits...hardware/software WTF!


SQL Server Training Kits...hardware/software WTF!

Author
Message
ronmoses
ronmoses
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1095 Visits: 996
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

GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47279 Visits: 44392
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, MVP, M.Sc (Comp Sci)
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


Vinod Suthar
Vinod Suthar
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 124
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.
Mark Eckeard
Mark Eckeard
SSC-Enthusiastic
SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)SSC-Enthusiastic (133 reputation)

Group: General Forum Members
Points: 133 Visits: 505
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



Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36162 Visits: 18751
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
My Blog: www.voiceofthedba.com
ronmoses
ronmoses
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1095 Visits: 996
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

Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36162 Visits: 18751
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
My Blog: www.voiceofthedba.com
ronmoses
ronmoses
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1095 Visits: 996
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

GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47279 Visits: 44392
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, MVP, M.Sc (Comp Sci)
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


ronmoses
ronmoses
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1095 Visits: 996
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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search