Bet you didn’t see that one coming ! While some people are still getting to grips with the excellent SQL 2012 , Microsoft has officially announced SQL 2014 at Tech Ed North America.
Your first stop should be Microsofts website , where you can sign up to be notified once the trial version is available. There are also 3 PDF documents at the bottom of that page that I highly recommend downloading.
Next , what exactly was announced in terms of features ? Just some of them :
1) Heckaton ! I’ve blogged about this before. It’s basically in-memory technology to give SQL Server OLTP applications a massive performance boost.
2) Writeable Column Store Indexes !! – A popular feature , and now your fact tables won’t be read-only once you create the index.
3) SSD Caching – extend memory by caching on an SSD. Also a performance boosting enhancement.
4) Extended Online Operations – more operations supported without taking database offline , and this extends uptime.
I’m sure that there are a whole lot more that we’ll learn about in the upcoming months. In the meantime , I recommend that you download those whitepapers at the Microsoft site and get reading !!