SQL Server 2014 is coming. Go ahead and download the public CTP.
Iโve just started getting my hands dirty with the new version. Based on that and on the stuff that has already been published, hereโs a few thoughts:
SQL Server 2014 is Mature
Microsoft takes care of a few open edges here: Columnstore Index is now updateable, online index operations can now work for a single partition, improved locking during partition management is added, and resource governor can now control IO. With other improvements to AlwaysOn and to query plans, itโs a very mature product.
SQL Server 2014 is โClassic Databaseโ Focused
The last few versions were more BI focused (some more, some less). Also, the emerging cloud era and the rise of Azure could make one fear Microsoft neglects the classic on-premise versions.
Well, SQL 2014 proves itโs not true. The new and improved features in this version, and especially Hekaton, show Microsoft still cherish the good old on-premise product.
Nonetheless, we still get better integration with Azure, which supports whatย Grant Fritcheyย andย Buck Woodyย say โ the future is in hybrid solutions.
Also, although itโs not a BI focused version, we still get two amazing features โ GeoFlowย (now called โPower Mapโ) and Data Explorerย (now called โPower Queryโ).
SQL Server 2014 is Aware of whatโs Going on
Microsoft is aware of the various technologies out there that enable fast loading and data retrieval. I donโt say it out of knowing, but I assume it was somewhere in the back their heads when they developed Hekaton, Columnstore Index and the ability to cache stuff on SSDโs. This also shows they are very aware of the massive hardware changes that occur lately. Without a doubt, it seems they did a good job.
SQL Server 2014 is Awesome!
Itโs an exciting version. go download it, experiment and share what you think.