Interview Question:Important New Features of SQL Server 2012, 2014 & 2016

Questions may be asked from the DBA prospective so I tried to collect few important features for SQL Server 2012,2014 and 2016 . Next blog will be published with explanation for each feature.

SQL Server 2012 Features:-

  1. Column store indexes
  2. Contained Database
  3. Sequencing Objects
  4. Pagination
  5. Error Handling
  6. User defined roles
  7. Windows server core support

SQL Server 2014 Features:-

  1. New In-Memory OLTP Engine
  2. Enhanced Windows Server 2012 Integration
  3. Enhancements to AlwaysOn Availability Groups
  4. Enhancements to Backups
  5. SQL Server Data tools for Business Intelligence
  6. Updateable Column store Indexes

SQL Server 2016 Features:-

  1. Always Encrypted
  2. Stretch Database
  3. Real Time Operational Analytics
  4. Poly Base into SQL Server
  5. Native JSON Support
  6. Enhancements to Always On
  7. Enhanced In-Memory OLTP
  8. Revamped SQL Server Data Tools

Note:  A brief description will be published for each feature in coming post.

Please like or comment if it is  beneficial for you.

Thank You!!!


About Mirza Husain

Mirza Husain is a senior consultant-database and having more than 10+ years of experience in the IT industry with different domains. He is fond of writing and speaking about SQL Server and also keen to learn new technologies. He is holding MCA degree and having Microsoft certifications as MCP & MCTS. He is also ITIL certified. In his past years, he worked with many clients as Microsoft, Bank of America etc. Currently he is associated with a France based client and offering his best services. You may reach him on his email id -- Thanks!
This entry was posted in Sql Server, Sql Server New Feature. Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your 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