Which version of SQL Server 2014 could

Posted on 2014-12-18
Last Modified: 2016-02-18
In windows 7 professional, my needs are desktop and developments. I also will be using SSRS, SSIS, SSAS.

Question: With these needs, which of the followings will best work for me?

You are welcome to include multiple options.

A. Microsoft SQL Server Data Tools for SQL Server 2014 CTP2 32/64-bit (English)    403 KB
B. SQL Server 2014 Business Intelligence 32-bit (English)  1 GB
C. SQL Server 2014 Business Intelligence 64-bit (English)  2 GB
D. SQL Server 2014 Developer Edition 32-bit (English)  1GB
E. SQL Server 2014 Developer Edition 64-bit (English)  2 GB
F. SQL Server 2014 Enterprise Core Edition 32-bit (English)  1 GB
G. SQL Server 2014 Enterprise Core Edition 64-bit (English)  2 GB
H. SQL Server 2014 Enterprise Edition 32-bit (English) 1 GB
I. SQL Server 2014 Enterprise Edition 64-bit (English)  2 GB
J. Microsoft SQL Server 2014 Express 32/64-bit (English) 175 MB
K. SQL Server 2014 Express with Advanced Services 32-bit (English)  1 GB
L. SQL Server 2014 Express with Advanced Services 64-bit (English)  1 GB
M. Microsoft SQL Server 2014 LocaldB 32/64-bit (English) 35 MB
N. SQL Server 2014 LocaldB 64-bit (English) 43 MB
O. SQL Server 2014 Management Studio 32-bit (English)  705 MB
P. SQL Server 2014 Management Studio 64-bit (English) 716 MB
Q. Microsoft SQL Server 2014 Standard Edition 32/64-bit (English)  1 GB
R. SQL Server 2014 Standard Edition 64-bit (English)  2 GB
S. Microsoft SQL Server 2014 Web Edition 32/64-bit (English)  1 GB
T. SQL Server 2014 Web Edition 64-bit (English) 2 GB

Sorry for the long list of options. I was not sure what to exclude.
Question by:Mike Eghtebas
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 25

Accepted Solution

chaau earned 300 total points
ID: 40508022
In my opinion you need to install SQL Server Developer edition. It costs a little (nothing if your have a MSDN subscription) but includes everything. You will only be able to use it for development though, not to hold the production data. BTW, according to Wikipedia (I did not verify it):

SQL Server Developer Edition includes the same features as SQL Server 2012 Enterprise Edition, but is limited by the license to be only used as a development and test system, and not as production server. This edition is available to download by students free of charge as a part of Microsoft's DreamSpark program.
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40508072
This is for single user just to practice and learn. I want to be able to have all the features possible. For example, partitioning is not possible in all versions; therefor, one can not practice it in some versions. And, there are more features like portioning I am not mentioning here (because I do not know about them at this point).
LVL 25

Expert Comment

ID: 40508083
As I said: why spending thousands of dollars on the Enterprise edition when you can buy a Developer edition (or have it for free if you are a student). You will have all the features the Enterprise edition has
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

LVL 25

Expert Comment

ID: 40508094
BTW, this MSDN page can help you in your decision if you want to buy a fully commercial edition. It looks like Enterprise edition is the most feature-rich (same as the Developer edition)
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 100 total points
ID: 40508101
E. SQL Server 2014 Developer Edition 64-bit (English)  2 GB
LVL 50

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 100 total points
ID: 40508687
Just go for the Developer Edition (32bit or 64bit depending on your Windows 7 version). It has ALL SQL Server features enabled.

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question