Solved

Sql server 2014 standard Edition

Posted on 2014-09-25
4
578 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
Comment Utility
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
Comment Utility
yes i saw that , But i need quick help from some one , i don't have time to read :).
0
 
LVL 14

Accepted Solution

by:
Vikas Garg earned 500 total points
Comment Utility
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
Comment Utility
Thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

772 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now