Solved

Question on SQL Server version...

Posted on 2014-12-18
4
164 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
Comment Utility
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 33

Author Comment

by:Mike Eghtebas
Comment Utility
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 500 total points
Comment Utility
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 33

Author Closing Comment

by:Mike Eghtebas
Comment Utility
Thank you.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now