

The business intelligence edition is sold as Server + CAL (Client Access License).Unlike the Enterprise edition, Business intelligence edition does not have the features like:.Another major feature available here is the Enterprise data management (Data Quality Services, Master Data Services).This edition also includes the Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine and advanced data mining).One among the highlights of business intelligence edition which is also available in the enterprise edition is the Self-service business intelligence option includes (Alerting, Power View, Power Pivot for Share Point Server, and so on).Just like the enterprise edition, A database can grow up to 524 PB.An instance can use the servers memory up to 128 GB.The Business Intelligence edition can use up to 16 processor cores.SQL Server 2014 Business Intelligence Edition The enterprise edition is priced in per core licensing model.Apart from this, it has all the features available in the business intelligence edition.In-memory OLTP, the Microsoft’s newest in-memory optimization technique is available only in the enterprise edition of SQL Server 2014.

It also has the Advanced high availability system (AlwaysOn, multiple, active secondaries, multi-site, and geo-clustering).Advanced security features available in enterprise edition are (SQL Server audit, transparent data encryption, and more).It has advanced data integration technique (Fuzzy grouping and lookup, change data capture).There is No limitation of memory utilization per instance either.It can use all the processors the server has. Enterprise edition has no limitation of processor cores.The other editions will have some limitations in these features. Enterprise edition in 2014 is the full featured edition of all the editions.
