Solved

Sql server 2014 standard Edition

Posted on 2014-09-25
4
604 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 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

830 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