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 http://www.sqlpass.org/summit/2014/PASStv.aspx?watch=7Pum0vfYtSk
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
ReplyDeleteSQL 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
ReplyDeleteThanks for sharing this article. As you mentioned SQL has playing a major role. well written. Do my Essays
ReplyDeleteYour 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 columbusmmug.com project and have some questions about code structure. This article helped me to find answers for them. Thank you for your work!
ReplyDelete