Saturday, November 8, 2014

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

image


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. 

image

image

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 .

image

Here is the syntax

image

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

3 comments:

  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

    ReplyDelete
  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

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

    ReplyDelete

 

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