SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Learning SQL Server 2012

By Site Owners,

This page is an attempt to list all the new features in SQL Server 2012 and give data professionals a place to begin learning about what has changed. Each of the topics below is described with a link to another page that contains various resources that can help you learn more about that particular topic.

If you find errors or ommissions for the topic list, please leave a comment on this article. If any of the specific topics has broken or missing links, please leave a comment on those pages.

The title for each section is the link to another page.

Columnstore Indexes

This technology was released in SQL Server 2012, and has been improved with each version. There are fewer limitations and more features with each evolution.

See the Columnstore Index links

In-Memory OLTP

Improvements have been made in SQL Server 2016 to the In-Memory OLTP tables and reducing limitations.

This technology was originally code-named "Hekaton" as the goal was to improve performance 100x. The technology was based on MIcrosoft research into in-memory databases and was first released in SQL Server 2014.

See the In-Memory OLTP links.

AlwaysOn

AlwaysOn is a suite of technologies that provide High Availability (HA) and Disaster Recovery (DR) capabilities for SQL Server. These technologies include Failover Clustered Instances (FCI) and Availability Groups (AG). There is no AlwaysOn technology by itself.

This was first introduced in SQL Server 2012 and has continued to be enhanced in future versions.

See AlwaysOn links.

 
Total article views: 1234 | Views in the last 30 days: 3
 
Related Articles
BLOG

Artikel „SQL Server 2014 – Neues Fundament“ in iX Ausgabe 5/2014, Richtigstellungen zu In-Memory OLTP und ColumnStore Indexes und warum AlwaysOn nicht gleich Always On ist

Article “SQL Server 2014 – New Fundament” in iX Issue 5/2014, corrections in In-Memory OLTP and Colu...

ARTICLE

Stairway to AlwaysOn Level 1: What is "SQL Server AlwaysOn"?

Level 1 of the stairway looks at exactly what the technologies "AlwaysOn", "Failover Cluster Instanc...

BLOG

Step by Step Guide to SQL Server AlwaysOn

AlwaysOn technology in MS SQL Server is designed to increase the availability of your database, it i...

BLOG

SQL Server 2016 AlwaysOn Availablility Enhancements

In this Article I have listed out SQL Server 2016 AlwaysOn Availability Enhancements.SQL Server 20...

ARTICLE

AlwaysOn Availability Groups in SQL Server 2012

This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new featu...

Tags
 
Contribute