Introduction to SQL Server 2012

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.


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."


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


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.


Guest Author: Deepak18 Jul 2012

Thanks for this post....
if u know more about SQL Server 2012, pl post in detail.This is useful for 2012 user's

Guest Author: Deepak18 Jul 2012

thanks for this post....
if u know more about SQL Server 2012, pl post in detail...
this is useful for 2012 user's

  • 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: