question

amartin256 avatar image
amartin256 asked

Recommended machine for sql server 2008 training

I am thinking about buying a standalone win8 machine 64 bit (laptop) to be used only for personal training in sql server (2008 or 2012) and ssis/ssas/BI. I want to buy off-the shelf from tigerdirect or similar and once done with it will repurpose it for other uses. I want to spend less than $1000 and wondered if this is reasonable and what everyone would recommend (mfr, o/s, disk, memory, processor). Thanks!
training
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks all for the input. I'm going to check out a rented VS and see how it goes
0 Likes 0 ·
KenJ avatar image
KenJ answered
I wouldn't recommend purchasing a dedicated machine for training on SQL Server. Rather, I would recommend that you set up a virtual SQL Server on a computer that you already have using VMWare, VirtualBox or Hyper-V: Jonathan Kehayias has a walk-through called "[Building a Completely Free Playground for SQL Server][1]" that will get you running with VirtualBox Microsoft have published "[How to Build a SQL Server 2012 Hyper-V Virtual Machine (KIWI build)][2]" that will get you running with Hyper-V In addition to, or in place of, the virtual machine on your own computer, you can also rent a virtual machine on-line (if you have reliable internet access in the locations you would be practicing). You can run SQL Server in a [Windows Azure virtual machine][3] or an [AWS virtual machine][4] for probably less than $10/month giving you almost 10 years of online playground before you've spent the $1000 you had planned for the laptop. If you do choose the new laptop approach, here is a [CNET list][5] of decent sub-$1,000 laptops. [1]: http://www.sqlskills.com/blogs/jonathan/building-a-completely-free-playground-for-sql-server-1-of-3-downloading-the-software-and-setting-up-a-windows-server-2008r2-vm-template/ [2]: http://social.technet.microsoft.com/wiki/contents/articles/3402.how-to-build-a-sql-server-2012-hyper-v-virtual-machine-kiwi-build.aspx [3]: http://www.windowsazure.com/en-us/manage/windows/common-tasks/sql-server-on-a-vm/ [4]: http://aws.amazon.com/windows/ [5]: http://reviews.cnet.com/8301-3121_7-57485614-220/laptops-we-love-under-$1000/
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered
I don't disagree with anything that Ken said (+1), but, if you don't have a decent machine currently and you do want to pursue the virtual route, unless you're only ever going to run a single virtual at a time, you really do need to put some memory behind the processes. I wouldn't go with anything less than 8gb. 16gb would be better. If you can get to 32gb, better still. With 16gb I can run a five server Availability Group with a sixth server acting as the domain controller. All on a laptop using virtuals. So, to the keep the price down, get a machine that's expandable to 16gb (or more), but don't pay that to the vendor. Instead, buy their minimal memory configuration and then buy the memory from someone else. Same thing if you think you want an SSD.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RAM is definitely your friend in this case!
0 Likes 0 ·
tomgough79 avatar image
tomgough79 answered
I would also add that it's a great excuse for buying a new and shiny computer of course!
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

amartin256 avatar image
amartin256 answered
To All: I set up an Azure VM and it is great - I have vs2010, ssms 2008 and 2012, along with the other pieces I need for training - free for the next 90 days, with a small charge ($10/mo) after that. Thanks for the advice!
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

great news!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.