Pr.Pg Next Pg

MS SQL Server 2012 Editions tutorials

  • MS SQL Server 2012 is available in different Editions which provides different feature and also target different business scenarios.

  • Each main edition comes in 32 bit and 64 bit version.

  • In MS SQL Server 2012 the Main editions are as follow

1)     Standard Edition

2)     Enterprise Edition

3)     Business Intelligence Edition.

 

Specialized Editions

1)     Developer Edition

2)     Web Edition

3)     Express Edition

 

SQL SERVER 2012 Standard Edition

·         Standard Edition is appropriate for medium class solutions, smaller organizations or department solutions.

·         It includes the core database engine as well as core reporting and analytics capabilities.

·         However it does not support all Enterprise features like data warehousing.

·         Maximum number of CPU upto 16 cores.

·         Supports upto 64 GB of RAM.

·         Basic OLTP (Online Transaction Processing)

·         Programmability (T-SQL, Data Types and File Table)

·         SQL Server Management Studio and Policy based Management.

·         Basic High Availability

·         Basic Corporate BI (Business Intelligence), Reporting, Analytics, Multidimensional Semantic Model and Data Mining.

·         Basic Data Integration (Built-in Data Connectors, Designer Transforms)

 

 

 

SQL SERVER 2012 Enterprise Edition

·         It is a flagship edition and contains all MS SQL Server 2012’s features.

·         It meets the highest demands of large-scale datacenters and data warehouse.

·         Suitable for mission critical performance and availability for Tier-1 Applications, highly Virtualized environment, large centralized or external business intelligence solutions.

·         Maximum number of CPU is subject to the Operating System being used.

·         Supports upto 64 GB of RAM.

·         Basic OLTP (Online Transaction Processing)

·         Programmability (T-SQL, Data Types and File Table)

·         SQL Server Management Studio and Policy based Management.

·         Basic High Availability

·         Basic Corporate BI (Business Intelligence), Reporting, Analytics, Multidimensional Semantic Model and Data Mining.

·         Basic Data Integration (Built-in Data Connectors, Designer Transforms)

·         Self-Service Business Intelligence (Alerting, Power View, PowerPivot for SharePoint Server)

·         Advanced Corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting

·         Advanced Data Integration (Fuzzy Grouping and Lookup, Change Data Capture, Advanced Data Mining)

·         Enterprise Data Management (Data Quality Services, Master Data Services)

·         Advance Security (SQL Server Audit, Transparent Data Encryption)

·         Data Warehousing (ColumnStore Index, Compression and Partitioning)

·         Advance High Availability (Multiple, Active Secondaries, Multi-sites and Geo-Clustering)

 

SQL SERVER 2012 Business Intelligence (BI)

·         It is a new edition of MS SQL Server which provides the core database engine, full reporting an analytic capabilities and full business intelligence services but it does not offer data warehousing features and security like Enterprise edition

·         It offers power BI capabilities such as scalable reporting and analytics, Power View and PowerPivot.

·         Maximum number of CPU is 16 Cores

·         Basic OLTP (Online Transaction Processing)

·         Programmability (T-SQL, Data Types and File Table)

·         SQL Server Management Studio and Policy based Management.

·         Basic High Availability

·         Basic Corporate BI (Business Intelligence), Reporting, Analytics, Multidimensional Semantic Model and Data Mining.

·         Basic Data Integration (Built-in Data Connectors, Designer Transforms)

·         Self-Service Business Intelligence (Alerting, Power View, PowerPivot for SharePoint Server)

·         Advanced Corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting

·         Advanced Data Integration (Fuzzy Grouping and Lookup, Change Data Capture, Advanced Data Mining)

·         Enterprise Data Management (Data Quality Services, Master Data Services)

  • Beyond above three main edition of MS-SQL SERVER 2012, Microsoft is offering following 3 specialized edition for organization that have a unique set of requirement.

 

Developer Edition of MS-SQL SERVER 2012

  • This edition includes all the features and functionality of SQL SERVER Enterprise Edition.

  • This edition is strictly meant for Development, Testing and Demonstration.

  • This edition can be transitioned directly into production by upgrading it to SQL Server Enterprise edition without reinstallation.

 

WEB Edition of MS-SQL SERVER 2012

  • This edition is meant for WEB Hosting company and Web service related company.

  • It can support upto 4 CPU Processor.

  • Support upto 64 GB of RAM Memory.

  • This edition doesn't have database size restriction.

  • Main point that add to it benefit is the price is much more affordable compare to Enterprise or Standard Edition.

 

Express Edition of MS-SQL SERVER 2012

  • The best part, it is FREE Edition.

  • It is entry-level alternative for software developer, student, hobbyists and nonprofessional developers.

  • It supports only 1 CPU Processor and 1 GB of RAM Memory.

  • The Maximum database size can go upto 10 GB only.

 


 

Pr.Pg border                                              Next Pg