Home > Home, SQL Server 2012 > SQL Server 2012 new Features

SQL Server 2012 new Features

Column store indexes

  • Non-clustered index
  • There is a limit of one columnstore index per table.
  • An index can be created before there is data in the table.
  • A table with a columnstore index cannot be updated

Column store indexesColumn store indexes_1

Contained database

  • Database with meta-data information, security information etc with in the database itself
  • Helps in migrating databases with user accounts

User Defined roles

  • Server Level Roles

User Defined roles


Tabular Model

Tabular Model


DQS Data Quality Services


DQS Flow

  • Build Rule

DQS-Build Rule

  • Transform Rule (IND to India)

DQS-Transform Rule

  • Create New DQS project

Create New DQS project

  • Select DataSource

DQS-Select DataSource

  • Process Data

DQS-Process Data

  • Result



Always On

  • AlwaysOn =Mirroring + Clustering
  • AlwaysOn they need to be in full recovery mode and backed up (preferably to a share that’s visible from the other nodes).

Always On Feature Disable Error

Always On


Hope you like this post.

Please provide your valuable feedback through liking the post or adding comments. It will help to encourage to do lot of similar stuff.



Learn Different BI Tools
Subscribe my YouTube Channel : Know BI Tools


  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: