Solved

Question on SQL Server version...

Posted on 2014-12-18
4
171 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 500 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

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…
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.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
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.

821 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