Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sql server 2014 standard Edition

Posted on 2014-09-25
4
Medium Priority
?
692 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
  • 2
4 Comments
 
LVL 49

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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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.
Suggested Courses

577 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