Solved

Sql server 2014 standard Edition

Posted on 2014-09-25
4
616 Views
Last Modified: 2016-02-18
Hi,
we are planing to buy Microsoft sql server 2014. with price we decided to buy MS sql server 2014 standard Edition.
Buying Microsoft sql sever 2014 main purpose is to Build Dataware house (using SSIS,SSAS and  SSRS).
01.Could some one let me know what is the best part going to ignore if i buy standard edition instead of BI Edition.
02. if i buy standard edition can i use SSIS,SSAS and  SSRS to build Datawrae house?
03. it possible to buy Microsoft Mobile App for Ipad separate?
04. it possible write MDX queries for standard Edition
Thanks
0
Comment
Question by:ukerandi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40345171
Have you used the comparison matrices Microsoft provide? They are quite detailed.
http://msdn.microsoft.com/en-us/library/cc645993.aspx
0
 
LVL 10

Author Comment

by:ukerandi
ID: 40345468
yes i saw that , But i need quick help from some one , i don't have time to read :).
0
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 500 total points
ID: 40345544
Hello,

01.Could some one let me know what is the best part going to ignore if i buy standard edition instead of BI Edition.
>> Some features will not be supported in Standard as compare to BI Edition
Example - Master Data Service, Perspectives in Cube, Writeback Dimensions, BI Semantic Model, Power Pivot

02. if i buy standard edition can i use SSIS,SSAS and  SSRS to build Datawrae house -
>> Yes You can

03. it possible write MDX queries for standard Edition -
>>Yes You can


Hope this would help you
0
 
LVL 10

Author Closing Comment

by:ukerandi
ID: 40348466
Thanks
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with Data Warehouse / Data Marts 4 42
CASE Statement using different fields 8 35
Powershell error using sql agent job 24 42
Begin Transaction 12 26
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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.
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.

710 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