Microsoft SQL Server 2012 On March 7

Microsoft Partners Platinum:-

Microsoft SQL Server 2012 On March 7th

Microsoft plans to launch SQL Server 2012 in three editions Enterprise, Business Intelligence and Standard. The Business Intelligence version will feature Power-View data discovery tool, data-quality services and many more useful features.

SQL Server is reducing the number of editions from 6 down to 4 (excluding all the different appliances here).  Those editions will be Express, Standard, Business Intelligence (BI), and Enterprise Edition. The express edition will still be a free edition with limited
functionality.

Microsoft rolled much of the SQL Server 2008 R2 Datacenter edition licensing rights into the SQL Server 2012 Enterprise edition, so the old Datacenter edition will disappear as a top product-line offering. Developer, Express and Compact editions will still be available after the SQL Server 2012 product is released, Microsoft indicated.

Enterprise Edition:-

The Enterprise edition is an all-inclusive product in terms of its features, and Enterprise Edition is majorly for for mission critical applications and large scale data warehousing.  This means that the Enterprise Edition will hold all the new features that are being introduced.

The Enterprise Edition of SQL Server 2012 will include all the features of the BI Edition as well as the Standard Edition.

Business Intelligence (BI) Edition:-
The Business Intelligence edition is a new product offering with 2012. It includes BI features while also including all of the features in the Standard edition. The new edition between the

Standard Edition and the Enterprise Edition called the BI Edition.  The BI Edition will include all the features of the Standard edition plus some extras. The licensing for the BI edition will only be available in a Server+CAL model.  There is no CPU core license available for the BI Edition. While the standard edition supports 16 cores for the database engine, the BI edition supports up to 20 cores for the database engine.  All of the BI services (SSAS, SSIS, SSRS) will support up to the OS maximum number of cores.

The BI edition will include the following features:-

•Data Quality Services
•Master Data Services
•Power View
•Power Pivot for SharePoint Services
•Semantic Model
•Advanced Analytics
The BI Edition will not include the following features:
•Advanced Auditing
•Transparent Data Encryption
•Column Store Index
•Data Compression
•Table/Index Partitioning
•Always On

Standard Edition:-
Microsoft recommends the Standard edition for basic database, reporting and analytics capabilities, according to its white-paper.  Standard edition will be available in either a Server + CAL license model or a CPU Core license model.  The costs for a server license or a CPU Core license remain the same as they were under SQL Server 2008 R2. 

There are some things to note about Standard Edition which are changing from prior editions. As for the support for other features in the standard edition of SQL Server 2012 not a lot of the details have been made available yet.  For the complete support features you’ll have to wait until we get closer to the release of the product.

The standard edition will NOT include the following features:-
•Data Quality Services
•Master Data Services
•Power View
•PowerPivot for SharePoint Services
•Semantic Model
•Advanced Auditing
•Transparent Data Encryption
•Column Store Index
•Data Compression
•Table/Index Partitioning
•Always On

Looking forward any comments, will be great.

Mehboob

Advertisements
%d bloggers like this: