Microsoft SQL Server 2012 Features

New features for SQL Server 2012 provide significant gains in performance and data insight capabilities, all with the expert support you expect from a trusted Microsoft Gold Certified Partner.

Faster Performance

Data Volume Management Optimization

Semantic Search and other built-in data features boost query performance, even across massive data sets.

15K Partitions

The expanded number of partitions in SQL Server 2012 supports significantly faster queries.

Enhanced Data Compression

Row and page compression for tables and indexes, configurable per partition, helps shrink data volumes by 50-60%, accelerating the performance of I/O intensive workloads.

Enhanced Data Insight

Semantic Search

Extend full-text search capabilities by enabling text-based and meaning-based queries.

ColumnStore Indexing

Integrated batch processing, segmentation elimination, and a highly compressed indexing format produce a 10-100x performance gain with complex BI queries.

Crescent Rapid Data Discovery & Self-Service Business Intelligence

Deliver highly interactive, web-based capabilities for exploring, visualizing, and presenting data for users of all levels.

Optimize Your Operations

Get the Most From Your Data

Business intelligence (BI) tools provide new ways of seeing your mission critical data, giving you the business insights you need to run and grow your operations.

Focus on Your Core Business

Consolidation and virtualization features reduce TCO while protecting your data and improving its availability.

Go to the Cloud on Your Terms

SQL Server 2012 offers the agility to rapidly create scalable solutions so your IT can keep pace with new business opportunities in the public cloud.

Depend on Microsoft Gold Certified Partner Expertise

Solution Design Consultation and 24x7x365 Support

PEER 1 Hosting infrastructure experts have experience supporting a vast and diverse array of customers leveraging SQL Server to address the most demanding big data challenges on the platform. Work with us to design, deploy, maintain and secure an optimized infrastructure solution that meets your unique business needs.