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
ReplyDeleteGreat Article Artificial Intelligence Projects
DeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
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
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!
ReplyDeletealat pembesar payudara
ReplyDeleteobat perangsang wanita dh2o
obat perangsang wanita opium spray
obat perangsang wanita blue wizard
obat perangsang wanita
obat perangsang wanita sex drop
obat perangsang wanita potenzol
alat penggeli puting susu
oil lintah papua
black mamba africa
I read that Post and got it fine and informative. Please share more like that...
ReplyDeletemanufacturing erp software in chennai
myTectra Placement Portal is a Web based portal brings Potentials Employers and myTectra Candidates on a common platform for placement assistance
ReplyDeletemobogenie download 9apps apk download appsara apk download
ReplyDeletemobogenie.website
ReplyDeletegetroutingnumber
https://moviebox.cc
moviebox app
https://megabox.fun
https://megabox.fun/mac/
https//droid4x.pro
ReplyDeleteمكافحة حشرات بالخبر افضل شركة مكافحة حشرات بالخبر
مكافحة حشرات بمكة افضل شركة رش حشرات بمكة
مكافحة حشرات بالمدينة المنورة افضل شركة رش حشرات بالمدينة المنورة
مكافحة حشرات بالدمام افضل شركة مكافحة حشرات بالدمام
Thanks for sharing
ReplyDeletePMP Certification In Hyderabad
Good Post! , it was so good to read and useful to improve my knowledge as an updated one, keep blogging.
ReplyDeletemua vé máy bay đi thượng hải
vé máy bay đi hàn quốc bao nhiêu tiền
giá vé máy bay đi osaka nhật bản
vé máy bay hà nội đi seoul
vé máy bay đi tokyo
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
ReplyDeleteGood post thanks for share information.
ReplyDeleteAppValley VIP APK
Cami Elliott
lola Iolani Momoa
rolling paper alternatives
Mp3boo
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
ReplyDelete