SQL SERVER 2012 Enterprise vs Business Intelligence vs Standard vs Web vs Express with Advanced Services vs Express with Tools vs Express December 10, 2012
Posted by juanpablo1manrique in SharePoint.trackback
Y en este mundo de las comparaciones …
| SQL SERVER 2012 | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Cross-Box Scale Limits | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1 | Operating System maximum | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores |
| Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services) 1 |
Operating system maximum | Operating system maximum | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores |
| Maximum memory utilized (SQL Server Database Engine) | Operating system maximum | 64 GB | 64 GB | 64 GB | 1 GB | 1 GB | 1 GB |
| Maximum memory utilized (Analysis Services) | Operating system maximum | Operating system maximum | 64 GB | N/A | N/A | N/A | N/A |
| Maximum memory utilized (Reporting Services) | Operating system maximum | Operating system maximum | 64 GB | 64 GB | 4 GB | N/A | N/A |
| Maximum relational Database size | 524 PB | 524 PB | 524 PB | 524 PB | 10 GB | 10 GB | 10 GB |
| High Availability (AlwaysOn) | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Server Core support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Log Shipping | Yes | Yes | Yes | Yes | |||
| Database mirroring | Yes | Yes (Safety Full Only) | Yes (Safety Full Only) | Witness only | Witness only | Witness only | Witness only |
| Failover Clustering | Yes (Node support: Operating system maximum | Yes (Node support: 2) | Yes (Node support: 2) | ||||
| Backup compression | Yes | Yes | Yes | ||||
| Database snapshot | Yes | ||||||
| AlwaysOn Availability Groups | Yes | ||||||
| SQL Server Multi-Subnet Clustering | Yes | ||||||
| Mirrored backups | Yes | ||||||
| Hot Add Memory and CPU2 | Yes | ||||||
| Database Recovery Advisor | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Scalability and Performance | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Multi-instance support | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
| Table and index partitioning | Yes | ||||||
| Data compression | Yes | ||||||
| Resource Governor | Yes | ||||||
| Partition Table Parallelism | Yes | ||||||
| Multiple Filestream containers | Yes | ||||||
| Security | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Basic Auditing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Fine Grained Auditing | Yes | ||||||
| Transparent database encryption | Yes | ||||||
| Extensible Key Management | Yes | ||||||
| User-Defined Roles | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Contained Databases | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Replication | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server change tracking | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Merge replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Transactional replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Snapshot replication | Yes | Yes | Yes | Yes (Subscriber only | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Heterogeneous subscribers | Yes | Yes | Yes | ||||
| Oracle publishing | Yes | ||||||
| Peer to Peer transactional replication | Yes | ||||||
| Management Tools | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Management Objects (SMO) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Configuration Manager | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL CMD (Command Prompt tool) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Management Studio | Yes | Yes | Yes | Yes | Yes | Yes | |
| Distributed Replay – Admin Tool | Yes | Yes | Yes | Yes | Yes | Yes | |
| Distributed Replay – Client | Yes | Yes | Yes | Yes | |||
| Distributed Replay – Controller | Yes (Enterprise supports up to 16 clients, Developer supports only 1 client) | Yes (1 client support only) | Yes (1 client support only) | Yes (1 client support only) | |||
| SQL Profiler | Yes | Yes | Yes | No2 | No2 | No2 | No2 |
| SQL Server Agent | Yes | Yes | Yes | Yes | |||
| Microsoft System Center Operations Manager Management Pack | Yes | Yes | Yes | Yes | |||
| Database Tuning Advisor (DTA) | Yes | Yes | Yes3 | Yes3 | |||
| RDBMS Manageability | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| User Instances | Yes | Yes | Yes | ||||
| LocalDB | Yes | Yes | |||||
| Dedicated admin connection | Yes | Yes | Yes | Yes | Yes (under trace flag) | Yes (under trace flag) | Yes (under trace flag) |
| PowerShell scripting support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SysPrep support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Support for Data-tier application component operations – extract, deploy, upgrade, delete |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Policy automation (check on schedule and change) | Yes | Yes | Yes | Yes | |||
| Performance data collector | Yes | Yes | Yes | Yes | |||
| Able to enroll as a managed instance in a multi-instance management | Yes | Yes | Yes | Yes | |||
| Standard performance reports | Yes | Yes | Yes | Yes | |||
| Plan guides and plan freezing for plan guides | Yes | Yes | Yes | Yes | |||
| Direct query of indexed views (using NOEXPAND hint) | Yes | Yes | Yes | Yes | |||
| Automatic indexed view maintenance | Yes | Yes | Yes | Yes | |||
| Distributed partitioned views | Yes | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable |
| Parallel indexed operations | Yes | ||||||
| Automatic use of indexed view by query optimizer | Yes | ||||||
| Parallel consistency check | Yes | ||||||
| SQL Server Utility control point | Yes | ||||||
| Contained Databases | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Development Tools | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Microsoft Visual Studio Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Developer Studio | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Intellisense (Transact-SQL and MDX) 1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Data Tools (SSDT) | Yes | Yes | Yes | Yes | Yes | ||
| SQL query edit and design tools1 | Yes | Yes | Yes | ||||
| Version control support1 | Yes | Yes | Yes | ||||
| MDX edit, debug, and design tools1 | Yes | Yes | Yes | ||||
| Programmability | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Common Language Runtime (CLR) Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Native XML support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| XML indexing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| MERGE & UPSERT Capabilities | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| FILESTREAM support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| FileTable | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Date and Time datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Internationalization support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Full-text and semantic search | Yes | Yes | Yes | Yes | Yes | ||
| Specification of language in query | Yes | Yes | Yes | Yes | Yes | ||
| Service Broker (messaging) | Yes | Yes | Yes | No (Client only) | No (Client only) | No (Client only) | No (Client only) |
| Web services (HTTP/SOAP endpoints) | Yes | Yes | Yes | Yes | |||
| TSQL endpoints | Yes | Yes | Yes | Yes | |||
| Integration Services | |||||||
|
Feature
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server Import and Export Wizard | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Built-in data source connectors | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SSIS designer and runtime | Yes | Yes | Yes | ||||
| Basic Transforms | Yes | Yes | Yes | ||||
| Basic data profiling tools | Yes | Yes | Yes | ||||
| Change Data Capture Service for Oracle by Attunity | Yes | ||||||
| Change Data Capture Designer for Oracle by Attunity | Yes | ||||||
| Integration Services – Advanced Adapters | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| High performance Oracle destination | Yes | ||||||
| High performance Teradata destination | Yes | ||||||
| SAP BW source and destination | Yes | ||||||
| Data mining model training destination adapter | Yes | ||||||
| Dimension processing destination adapter | Yes | ||||||
| Partition processing destination adapter | Yes | ||||||
| Change Data Capture components by Attunity | Yes | ||||||
| Connector for Open Database Connectivity (ODBC) by Attunity | Yes | ||||||
| Integration Services – Advanced Transforms | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Persistent (high performance) lookups | Yes | ||||||
| Data mining query transformation | Yes | ||||||
| Fuzzy grouping and lookup transformations | Yes | ||||||
| Term extractions and lookup transformations | Yes | ||||||
| Master Data Services | |||||||
|
Feature
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Master Data Services database | Yes | Yes | |||||
| Master Data Manager web application | Yes | Yes | |||||
| Data Warehouse | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Create cubes without a database | Yes | Yes | Yes | ||||
| Auto-generate staging and data warehouse schema | Yes | Yes | Yes | ||||
| Change data capture | Yes | ||||||
| Star join query optimizations | Yes | ||||||
| Scalable read-only Analysis Services configuration | Yes | ||||||
| Parallel query processing on partitioned tables and indices | Yes | ||||||
| xVelocity memory optimized columnstore indexes | Yes | ||||||
| Analysis Services | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Scalable Shared Databases (Attach/Detach, Read only databases) | Yes | Yes | |||||
| High Availability | Yes | Yes | Yes | ||||
| Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) | Yes | Yes | Yes | ||||
| BI Semantic Model (Multidimensional) | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Semi-additive Measures | Yes | Yes | No1 | ||||
| Hierarchies | Yes | Yes | Yes | ||||
| KPIs | Yes | Yes | Yes | ||||
| Perspectives | Yes | Yes | |||||
| Actions | Yes | Yes | Yes | ||||
| Account intelligence | Yes | Yes | Yes | ||||
| Time Intelligence | Yes | Yes | Yes | ||||
| Custom rollups | Yes | Yes | Yes | ||||
| Writeback cube | Yes | Yes | Yes | ||||
| Writeback dimensions | Yes | Yes | |||||
| Writeback cells | Yes | Yes | Yes | ||||
| Drillthrough | Yes | Yes | Yes | ||||
| Advanced hierarchy types (Parent-Child, Ragged Hiearchies) | Yes | Yes | Yes | ||||
| Advanced dimensions (Reference dimensions, many-to-many dimensions | Yes | Yes | Yes | ||||
| Linked measures and dimensions | Yes | Yes | |||||
| Translations | Yes | Yes | Yes | ||||
| Aggregations | Yes | Yes | Yes | ||||
| Multiple Partitions | Yes | Yes | Yes, up to 3 | ||||
| Proactive Caching | Yes | Yes | |||||
| Custom Assemblies (stored procs) | Yes | Yes | Yes | ||||
| MDX queries and scripts | Yes | Yes | Yes | ||||
| Role-based security model | Yes | Yes | Yes | ||||
| Dimension and Cell-level Security | Yes | Yes | Yes | ||||
| Scalable string storage | Yes | Yes | Yes | ||||
| MOLAP, ROLAP, HOLAP storage modes | Yes | Yes | Yes | ||||
| Binary and compressed XML transport | Yes | Yes | Yes | ||||
| Push-mode processing | Yes | Yes | |||||
| Direct Writeback | Yes | Yes | |||||
| Measure Expressions | Yes | Yes | |||||
| BI Semantic Model (Tabular) | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Hierarchies | Yes | Yes | |||||
| KPIs | Yes | Yes | |||||
| Semi-additive Measures | Yes | Yes | |||||
| Perspectives | Yes | Yes | |||||
| Translations | Yes | Yes | |||||
| DAX calculations, DAX queries, MDX queries | Yes | Yes | |||||
| Row-level Security | Yes | Yes | |||||
| Partitions | Yes | Yes | |||||
| In-Memory and DirectQuery storage modes (Tabular only) | Yes | Yes | |||||
| PowerPivot for SharePoint | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SharePoint farm integration based on shared service architecture | Yes | Yes | |||||
| Usage reporting | Yes | Yes | |||||
| Health monitoring rules | Yes | Yes | |||||
| PowerPivot Gallery | Yes | Yes | |||||
| PowerPivot Data Refresh | Yes | Yes | |||||
| PowerPivot Data Feeds | Yes | Yes | |||||
| Data Mining | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Standard Algorithms | Yes | Yes | Yes | ||||
| Data Mining Tools (Wizards, Editors Query Builders) | Yes | Yes | Yes | ||||
| Cross Validation | Yes | Yes | |||||
| Models on Filtered Subsets of Mining Structure Data | Yes | Yes | |||||
| Time Series: Custom Blending Between ARTXP and ARIMA Methods | Yes | Yes | |||||
| Time Series: Prediction with New Data | Yes | Yes | |||||
| Unlimited Concurrent DM Queries | Yes | Yes | |||||
| Advanced Configuration & Tuning Options for Data Mining Algorithms | Yes | Yes | |||||
| Support for plug-in algorithms | Yes | Yes | |||||
| Parallel Model Processing | Yes | Yes | |||||
| Time Series: Cross-Series Prediction | Yes | Yes | |||||
| Unlimited attributes for Association Rules | Yes | Yes | |||||
| Sequence Prediction | Yes | Yes | |||||
| Multiple Prediction Targets for Naïve Bayes, Neural Network and Logistic Regression | Yes | Yes | |||||
| Reporting Services Features | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Supported catalog DB SQL Server edition | Standard or higher | Standard or higher | Standard or higher | Web | Express | ||
| Supported data source SQL Server edition | All SQL Server editions | All SQL Server editions | All SQL Server editions | Web | Express | ||
| Report server | Yes | Yes | Yes | Yes | Yes | ||
| Report Designer | Yes | Yes | Yes | Yes | Yes | ||
| Report Manager | Yes | Yes | Yes | Yes | Yes | ||
| Role based security | Yes | Yes | Yes | Yes | Yes | ||
| Word Export and Rich Text Support | Yes | Yes | Yes | Yes | Yes | ||
| Enhanced gauges and charting | Yes | Yes | Yes | Yes | Yes | ||
| Export to Excel, PDF, and Images | Yes | Yes | Yes | Yes | Yes | ||
| Custom authentication | Yes | Yes | Yes | Yes | Yes | ||
| Report as data feeds | Yes | Yes | Yes | Yes | Yes | ||
| Model support | Yes | Yes | Yes | Yes | |||
| Create custom roles for role-based security | Yes | Yes | Yes | ||||
| Model Item security | Yes | Yes | Yes | ||||
| Infinite click through | Yes | Yes | Yes | ||||
| Shared component library | Yes | Yes | Yes | ||||
| Email and file share subscriptions and scheduling | Yes | Yes | Yes | ||||
| Report history, execution snapshots and caching | Yes | Yes | Yes | ||||
| SharePoint Integration | Yes | Yes | Yes | ||||
| Remote and non-SQL data source support1 | Yes | Yes | Yes | ||||
| Data source, delivery and rendering, RDCE extensibility | Yes | Yes | Yes | ||||
| Data driven report subscription | Yes | Yes | |||||
| Scale out deployment (Web farms) | Yes | Yes | |||||
| Alerting2 | Yes | Yes | |||||
| Power View2 | Yes | Yes | |||||
| Reporting Services : Report Server Database Server Edition Requirements | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Use this edition of the Database Engine instance to host the database | Standard, Business Intelligence Enterprise, editions (local or remote) | Standard, Business Intelligence Enterprise, editions (local or remote) | Standard, Enterprise editions (local or remote) | Web edition (local only) | Express with Advanced Services (local only). | ||
| Business Intelligence Clients | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Report Builder | Yes | Yes | Yes | ||||
| Data Mining Addins for Excel and Visio 2010 | Yes | Yes | Yes | ||||
| PowerPivot for Excel 2010 | Yes | Yes | |||||
| Master Data Services Add-in for Excel | Yes | Yes | |||||
| Spatial and Location Services | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Spatial indexes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Planar and Geodetic datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Advanced spatial libraries | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Import/export of industry-standard spatial data formats | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Additional Database Services | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server Migration Assistant | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Database mail | Yes | Yes | Yes | Yes | |||
| Other Components | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Data Quality Services | Yes | Yes | |||||
| StreamInsight | StreamInsight Premium Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | |||
| StreamInsight HA | StreamInsight Premium Edition | ||||||
Tomado de http://msdn.microsoft.com/en-us/library/cc645993.aspx
Letras y Números 
Hey I am so grateful I found your blog, I really found you by mistake, while I was looking on
Google for something else, Anyways I am here
now and would just like to say many thanks for a remarkable post and
a all round interesting blog (I also love the theme/design), I don’t have time to go through it all at the minute but I have bookmarked it and also
added in your RSS feeds, so when I have time I will be back to read much more, Please do keep up the
awesome jo.