6 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 http://www.sqlpass.org/summit/2014/PASStv.aspx?watch=7Pum0vfYtSk