Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Question on SQL Server version...

Posted on 2014-12-18
4
Medium Priority
?
180 Views
Last Modified: 2014-12-19
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
0
Comment
Question by:Mike Eghtebas
  • 2
  • 2
4 Comments
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 40508237
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
 
LVL 34

Author Comment

by:Mike Eghtebas
ID: 40508264
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
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 2000 total points
ID: 40508283
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
 
LVL 34

Author Closing Comment

by:Mike Eghtebas
ID: 40509551
Thank you.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

810 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