Choice of Windows 7 version

Please advise which of the following is most cost effective for MSSQL2008(Database Design/Programming, SSRS, SSIS, SSAS), WCF, WPF, Silverlight, MVC, and .NET 4/3.5 development:

Windows 7 Home Premium

Windows 7 Professional

Note the OS will run on a local development laptop that may deploy to a remote server thru a LAN or the internet.

Thanks.
ksfokAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
It is a work / development project if I read correctly, so use Windows 7 Pro. I see many posts that go like "I purchased Home and now cannot do what I want". I never recommend Home and here I really think you should use Pro anyway. ... Thinkpads_User
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnBusiness Consultant (Owner)Commented:
I forgot to add that if you want to use remote server and similar network functions, you really must use Pro.
... Thinkpads_User
0
AshokSr. Software EngineerCommented:
Windows 7 Professional

Home Premium may give you hard time in some cases when developing applications.

I personally have never used Home editions for development purpose.

Ashok
0
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

ksfokAuthor Commented:
I have found a new laptop bundled with WIN 7 Home.
Can I go ahead buy it and upgrade it to WIN 7 Pro using a download upgrade license from MS?
Please advise.
Thanks.
0
ViRoguesCommented:
You can use that laptop and upgrade to Pro, but if you can get it with Pro already installed, that would be better as it would save you time and money.

 - ViRogues
0
JohnBusiness Consultant (Owner)Commented:
With Windows 7 Anytime Upgrade, yes, you can upgrade it to Pro, but beware two things: (1) there will be a charge from Microsoft to do this, and (2) it is not a certainty that the PC will support the upgrade. You need the seller to agree or take it back if it fails. Generally, I find it better and more convenient to purchase the PC with the OS that you want already installed. You do have options, though, as I have noted.
... Thnkpads_User
0
ksfokAuthor Commented:
What are the options?
0
JohnBusiness Consultant (Owner)Commented:
You must use Windows 7 Pro for your purposes as I noted in my first post. So:
1. You can purchase a Windows 7 Pro laptop (best option), or
2. See if a Windows 7 Home machine can be upgraded (seller will know) with Windows 7 Anytime Upgrade.
... Thinkpads_User
0
abelCommented:
Just a note to add to everything already mentioned: MSSQL2008 runs pretty poorly on almost any laptop. MS SQL Express has a smaller memory footprint (but still runs poorly). For MS SQL Server alone, Windows Server 2008 or Windows Server Database Edition is your best bet, but you wouldn't ever want to run that from a laptop. The difference? Desktop systems like Windows 7 are not meant for direct disk access and firewalls, virus scanners and heuristical scanners get in your way.

When I setup a dev. environment and need several databases I often find it easier to use a (company's) server's space or database that's meant for developing purposes and connect to it remotely. Or, if I must have it on my dev machine, I use MySQL where I can, to speed up development. But not all projects allow you to choose the database... (if you use some database neutral mapping, you could).

I don't mean to say that MS SQL 2008 is bad. It is not. But on a laptop, you'll will quickly wonder why either your laptop or MS SQL runs so slowly and why you bothered to buy a brand new laptop anyway.
0
ViRoguesCommented:
Here is a short list of differences between the editions.

http://www.microsoft.com/windows/windows-7/compare/default.aspx
0
JohnBusiness Consultant (Owner)Commented:
This thread was about a laptop, so I will stay on that course for the time being. If you do want to go ahead with a laptop, and you know now you must use Windows 7 Pro, then get a 64-bit laptop with at least 4Gb of memory and a large, fast (7200-rpm) hard drive. Then get it with Windows  Pro 64-bit. Such a machine (my Thinkpad T61p is as I described above) is very fast and very powerful. I know it stands up to anything I can throw at it, but I would take the advice about about MSSQL2009 to heart. ... Thinkpads_User
0
ksfokAuthor Commented:
Please elucidate the issue of 32 bit and 64 bit in installing SQL2008, VS2008, and Windows 7 Pro? Should they be installed with 64 bit alternately or uniformly? Thanks.
0
JohnBusiness Consultant (Owner)Commented:
New microsoft products work fine on Windows 7 Pro 64-bit. I have not tried to run SQL on my Thinkpad, but everything else from Microsoft runs fine. .... Thinkpads_User
0
abelCommented:
SQL 2008 works fine both on 64 and 32 bits out of the box. However, as a typical server program, for years it has been built to make excellent use of the extra address space available on 64 bit Windows and UAE on 32 bit Windows with > 4GB memory. But for your laptop requirements these should not matter, it will "just work" (albeit slowly...).
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.