<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server Newbies
»
SQL Server Training Kits...hardware/software...
12 posts, Page 1 of 2
1
2
»»
SQL Server Training Kits...hardware/software WTF!
Rate Topic
Display Mode
Topic Options
Author
Message
ronmoses
ronmoses
Posted Friday, August 17, 2012 11:44 PM
Say Hey Kid
Group: General Forum Members
Last Login: Today @ 11:49 AM
Points: 662,
Visits: 699
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
GilaMonster
GilaMonster
Posted Saturday, August 18, 2012 2:26 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 38,095,
Visits: 30,387
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
Vinod Suthar
Vinod Suthar
Posted Saturday, August 18, 2012 5:19 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, May 17, 2013 5:10 AM
Points: 42,
Visits: 91
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
Mark Eckeard
Mark Eckeard
Posted Saturday, August 18, 2012 11:46 AM
SSC Journeyman
Group: General Forum Members
Last Login: Today @ 5:56 AM
Points: 82,
Visits: 350
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Saturday, August 18, 2012 12:26 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
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
ronmoses
ronmoses
Posted Saturday, August 18, 2012 12:33 PM
Say Hey Kid
Group: General Forum Members
Last Login: Today @ 11:49 AM
Points: 662,
Visits: 699
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Saturday, August 18, 2012 12:43 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
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
ronmoses
ronmoses
Posted Tuesday, August 21, 2012 9:07 AM
Say Hey Kid
Group: General Forum Members
Last Login: Today @ 11:49 AM
Points: 662,
Visits: 699
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
GilaMonster
GilaMonster
Posted Tuesday, August 21, 2012 9:17 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 38,095,
Visits: 30,387
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
ronmoses
ronmoses
Posted Tuesday, August 21, 2012 9:26 AM
Say Hey Kid
Group: General Forum Members
Last Login: Today @ 11:49 AM
Points: 662,
Visits: 699
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 »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
