Capabilities

Enhanced high availability

Gain greater uptime, faster failover, improved manageability, and better use of hardware resources through AlwaysOn for high availability. AlwaysOn provides up to four active, readable secondaries, greater online operations, and an integrated dashboard for managing high availability.

In-memory performance

Enable breakthrough performance across data warehousing, analytics, and business intelligence. In-memory capabilities are built right into the SQL Server database and analytics engines for flexibility and ease of use.

Enterprise scalability

Achieve high scale in traditional on-premises as well as highly virtualized deployments with Windows Server 2012 R2. Physical processing can scale up to 640 logical processors and virtual machines scale up to 64 logical processors with 1 TB of RAM.

Self-service business intelligence

Unlock new insights via Power View, a highly interactive data exploration and visualization tool for business analysts and end users. Power View supports visualization for both the tabular and multi-dimensional analytical models.

Robust data quality

Improve data quality by using organizational knowledge and 3rd party reference data providers to profile, cleanse, and match data through Data Quality Services.

Enhanced security

Increase manageability related to auditing with audit resilience, filtering, user-defined audit, and the ability to audit actions across all editions.

Things you can do

Run Tier 1 workloads

Today’s world of continuous services and connected devices demands that applications and data will be up and available, scalable, and secure. SQL Server Enterprise is designed to support today’s most demanding enterprise applications with built-in mission-critical capabilities.

Unlock new insights

SQL Server supports scalable data warehousing, data cleansing and management, and rapid data exploration and visualization for end users. Enterprise includes all the business intelligence functionality included in SQL Server Business Intelligence edition.

Enable flexibility in deployment

Quickly create and scale innovative Hybrid IT solutions across on-premises, private or public cloud. Connection points in SQL Server make it easy to take advantage of Microsoft Azure's benefits glued together with common tools to build, extend, and manage.

Parallel Data Warehouse

Customers who require a massively parallel processing (MPP) data warehouse now have access to PDW through their Enterprise Edition core licenses with Software Assurance.