Solved

Question on SQL Server version...

Posted on 2014-12-18
4
169 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 33

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 33

Author Closing Comment

by:Mike Eghtebas
ID: 40509551
Thank you.
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

777 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