Introduction to SQL Server 2012

Posted Date: 02-Jul-2012	Category: General
Author: Nandhini	Member Level: Gold	Points: 25

Microsoft has released SQL Server 2012 on march 2012 and the licensed version was available for download from April 2012. SQL Server database has the primary focus on Business Intelligence functionality high-availability self-service and a good query performance. It has introduced a new tool to unify itself with cloud “SQL Azure” for integration of business intelligence tools with unstructured data.

Introduction

It also introduced new & improved tools under Master Data Services and SQL Server Data Quality Services for data integration and management that deliver consistent, credible data at the right time. Basically SQl server 2012 is released with the punch line "any data, any size, anywhere."

Highlights

Always on Availability groups

"Always on Availabitlity Groups" can contain multiple databases and all of them can be automatically falled as a unit. This is useful in case of large applications where there could be several databases which require distinct mirroring sessions

Column Store Indexes

Data is grouped and stored in a flat, compressed column index, greatly reducing I/O and memory utiization on large queries.

Linux Platform

ODBC Driver is introduced for SQl Server to run on Linux platform as well.

Big Data Support

It has introduced new storage options and tools for big data analysis

xVelocity

With the in-memory technologies, the performance of data-warehouse and analytics feature may increase upto 100 times.

Query Performance

The new spatial indexing feature can process many geospatial queries faster than in predecessors.

Contained Database

This reduces the effort required to migrate a database to a new instances as it reduces the work involved in reproducing and validating the dependcies.

Post Comment:

Notify me by email when others post comments to this article.

Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.

No HTML formatting and links to other web sites are allowed.

This is a strictly moderated site. Absolutely no spam allowed.

Name:	Sign In to fill automatically.
Email:	(Will not be published, but required to validate comment)
	Type the numbers and letters shown on the left.

Online Members