SQL Server Code Name “Denali” CTP3 is available for download. You can get it here: https://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx

There are a bunch of new things in this CTP, Apollo (column store indexes), some new date functions, new parse functions and more goodies

Be advised that you need Internet Explorer to download CTP3, it requires the Download Manager which is invoked via an ActiveX control. I could not get the download to work with Chrome