SQL Server2012 New features Overview

The company recently upgraded the database to SQL Server 2008r2-->2012. Before you start the upgrade, find a bit of data to analyze the new features and functions of 2012, pre-warming up a bit.

The 2012 focuses on three areas:

Performance: Improved core support, column storage cable, stronger compression capability and AlwaysOn features;

Self-service: With the help of new data exploration tools such as Power View, SQL Azure bussiness intellingence (BI), data quality and master data options, and PowerPivot for SharePoint improvements, Enables users to access data at any time, anywhere, and to quickly query and deliver intelligent information.

Integration and collaboration: Reporting Services, PowerPivot and life verification are integrated in SharePoint 2010, and the SQL2012 release provides a solid foundation for self-service focus.

New features:

1. Production DBA, production DBA to ensure that the production database does not go down, if there is a outage, DBAs need to recover the database, but also to ensure that the server in the best way I run, to facilitate the database from development to QA, to production. Other tasks include:

AlwaysOn: An availability feature that includes availability groups and behavior that mimics the application of a database failover as a group.

FileTable: Additional file-based data storage.

Extended time: Provides a lightweight, wide-coverage tracking capability.

Stronger stability and distributed replay capability.

Improved debugging capabilities, including support for expression and breakpoint validation.

Columnstore indexes, which are used to optimize large data volumes.

Improved statistical algorithms for super-large databases.

Improved compression and partitioning capabilities.

2. Development DBA: The requirement ensures that all stored procedures are written optimally, the database is physically and logically modeled correctly, and the previous procedure is written to upgrade the database version. The new features are as follows:

New T-SQL and spatial data capabilities.

SQL Server DATA Tools: Has been integrated into the new VS development environment.

New DAX expression language with multidimensional data processing capabilities.

As a new tabular model: memory-Optimized OLAP technology presents a form of rapid acquisition value.

3.BIDBA: Focus on best practices, optimization, and use of the BI toolset, creating SSIS to perform extraction, transformation, loading procedures, or reports (ETL) for users. Is consulted about the physical implementation of SSIS and SSAS multidimensional data. Need to focus on new features:

Modeling consulting for Analysis Services cubes and solutions.

Create a report using reporting Services.

Use SSIS to create ETL and provide consulting.

Quickly discover data using Power view and Power point.

Hosted self-service bi.

Use data quality Services and master data managenment to obtain trusted and consistent information.

Use parallel Data Warehouse and reference architectures to implement robust DW solutions.

Summary: The presentation and advantages of the new features depend on the way SQL is used and the role of the user, there are a lot of exciting features in 2012, some can be quickly started, but the actual effect is also in the real environment to show, any out of the context of the function of the most is also on paper, Also learn to use our DBA in practice.

References: Professional Microsoft SQL Server adminnistration

SQL Server2012 new features overview