Question on SQL Server version...

Could you please help me with the following questions?

A. Microsoft SQL Server Data Tools for SQL Server 2014 CTP2 32/64-bit (English)    403 KB
Q1: What are some of the examples of the Data Tools?

B. SQL Server 2014 Business Intelligence 32-bit (English)  1 GB
Q2: What activity are BI referred to:

F. SQL Server 2014 Enterprise Core Edition 32-bit (English)  1 GB
Q3: What is the difference between core edition and item H below?

H. SQL Server 2014 Enterprise Edition 32-bit (English) 1 GB
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
1) Yes. Most features were merged into the Visual Studio IDE - especially anything related to development (stored procs, table designers, etc)

2) Each of the BI tools are optional features you can pick and choose from during installation. Different versions support different features, and some versions support a subset of certain features.  You're best looking at the Microsoft documentation for what features come with which version here: http://msdn.microsoft.com/en-us/library/cc645993.aspx

3) SQL Server Developer Edition supports all of the features of Enterprise Edition. The licence just doesn't cover you for actually hosting any production systems.  But if you want it to learn with then Developer edition is what you want.
0
 
Carl TawnSystems and Integration DeveloperCommented:
1) Data Tools basically refers to Visual Studio, which replaced Management Studio as the development IDE for SQL Server.

2) The BI tools collectively refers to Reporting Services, Analysis Services, Master Data Services and Integration Services.

3) Core and Enterprise editions differ only in the licencing model and maximum number of cores supported.
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Hi Carl,

Thank you for the post.

BTW, I have windows 7 professional in case it was necessary.

1) Data Tools basically refers to Visual Studio, which replaced Management Studio as the development IDE for SQL Server.
I will be also installing visual studio 2013. So, basically what you are saying Data Tool add similar functionality as  SSMS has into visual studio, correct?

2) The BI tools collectively refers to Reporting Services, Analysis Services, Master Data Services and Integration Services.
One installs it to an existing installation of SQL Server to make it BI enabled? If so, can it be added to Express version or there is limited to developer, for example, and up?

3) Core and Enterprise editions differ only in the licencing model and maximum number of cores supported.
This is for single user practice and learning, so which version should I go? I know developer should be just as fine, but I like to be able to study and practice the high-end features for certification purpose.

Thanks,

Mike
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Thank you.
0
All Courses

From novice to tech pro — start learning today.