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

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

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

Thanks

Prasad

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

 

Advertisements
  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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: