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.
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 sessionsColumn 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 analysisxVelocity
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.
Thanks for this post....
if u know more about SQL Server 2012, pl post in detail.This is useful for 2012 user's