Mike Eghtebas
asked on
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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you.
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.