Saturday, November 8, 2014

17 SQL Server vNext

Despite many people may expect that Microsoft will announce some sort of roadmap for the next release of SQL Server in the PASS SUMMIT held in Seattle last week ( Nov 4th – Nov 7th ).

There is not really much new stuff being show in the conference . However, if you pay attention on the keynote and sessions, there are still some clues for what may be part of new feature in the next release.

For instance, below is one of the slide that high light the new feature for the Azure SQL Database. Since I don’t use Azure SQL DB, it is not good enough for me.


But wait, there is more in the key note and sessions for database new feature that I like to share with you: 

  • Non clustered column store index for memory optimized table
  • Stretch table to Azure
  • Query store

non clustered column store index for memory optimized table

In SQL 2014 memory optimized table, the table structure is defined during the table creation time. We can not change the table structure nor alter index afterward.  During the keynote day 1 demo, the Microsoft has combine column stored index and memory optimized table. 



Stretch table to Azure

Stretch table allow we move some of the data for particular table to azure. In the event of the disaster recovery, SQL Server can sync the data state between on premises and the cloud .


Here is the syntax


Query store

I could not remember how many times I have asked developer did you keep the old query plan so we can compare the existing query plan .

The SQL 2014 already has the extend event for the query store but it is empty. The code probably is not  ready for production but now there is a light .

In the future release, SQL Server would keep all the query plan in the meta data table. The table is special memory optimized table and we can control how often the table would flush to the disk. The table would be durable which means it would not get reset after server bounce like DMV.  we will be able to easily force the plan and there would be no need to use the plan guide anymore.

In Conor Cunningham’s word “ Query store do ~~

For those who miss the SUMMIT, you can watch some of the recording from here


  1. i love this text. it's far provide more statistics to me. I’m very fired up to reveal it to absolutely everyone. It makes me so glad. thanks for sharing this publish. Feel free to surf custom essay writing service

  2. SQL has wide application in every here and there. So SQL has a important role. This article surely specifying the relevance and needs of SQL. There are so many SQL commands we may not familiar with that. Website like these will help to find those. Custom Essay Writing Service UK

  3. Thanks for sharing this article. As you mentioned SQL has playing a major role. well written. Do my Essays

  4. Your blog is very interesting and informative! I'm waiting for every post and like to read them and to get new knowledge. Today I'm working on project and have some questions about code structure. This article helped me to find answers for them. Thank you for your work!

  5. I read that Post and got it fine and informative. Please share more like that...
    manufacturing erp software in chennai

  6. myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance

  7. Really nice information, This information will always help to everyone for gaining knowledge. So please always share your valuable information. I am very thankful to you for providing good information.IT solutions company

  8. I read this article, it is really informative one. Your way of writing and making things clear is very impressive. Thanking you for such an informative article. cloud migration houston tx



SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates