I hope this note will help you to finish the project. This is for Case Project 1-1: Selecting a SQL Server 2012 Edition. Name of the Book is Introduction to SQL Server 2012 (MCSA Guide to Microsoft SQL Server 2012 (exam 70-462))
Current version of SQL server is 2016. But I can see that we are interested in SQL server 2012. I did some research on different editions of SQL server 2012 Editions.
My research led to msdn.microsoft.com where I was able to find differences between SQL server 2012 editions. According to my research we should only consider Enterprise or the Business Edition. Here are the differences per Microsoft website:
- SQl server 2012 Enterprise: Enterprise edition is recommended for business. According to Microsoft msdn this edition is comprehensive, mission-critical in-memory performance with unparalleled security, mission critical high availability, an end-to-end enterprise business intelligence solution. This edition also includes built in mobile BI. It supports unlimited virtualization with software assurance.
- SQl server 2012 Business: In this edition, there are some limitation in high availability, Scalability and Performance. We will not get all high functionality as Enterprise edition.