SQL Server 2014 CTP release

Just when we thought we were getting used to SQL server 2012, Microsoft unveils 2014 CTP1!

I still have a lot of reading to do on SQL 2012… So my initial feelings are denial! Then I realize that I cannot alter this fact, and I get over it. (Isn’t IT good for helping us accept change in life!) A little investigation shows that SQL server 2014 is destined to adopt, amongst other things, a new high volume, in-memory OLTP technology. Codename “Hekaton”…

Sounds cool right!

You can read more about Hekaton here: http://research.microsoft.com/en-us/news/features/hekaton-122012.aspx
And you can read more on SQL 2014 here: http://www.brentozar.com/archive/2013/06/almost-everything-you-need-to-know-about-the-next-version-of-sql-server/

To checkout Dave Ballantyne tearing Hekaton apart, go here:
http://dataidol.com/davebally/2013/07/03/first-steps-into-hekaton-xe-slow-parameter-passing/

Meanwhile… I am busy trying to get covered off with my SQL server 2012 skills! Let alone a version that is not even out yet… But a new version of SQL is too exciting to refuse!

To get started, download SQL server 2014 CTP1 here:
http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx

Take note that it can only be installed on a 64 bit platform and cannot coexist with any other SQL installation.

I have chosen to use Oracle’s VirtualBox to create a fresh VM using a trial version of windows 2012. But you can use whatever platform you like, as long as it meets the minimum requirements.

As always with a CTP version, the finished product may or may not contain the exact features that we are looking at… But let’s not wait to get started!
Finalize your install like any other by reviewing the setup log, and verifying that the data files and binaries exist where you wanted them. Make sure the services start and are running under the correct context. Then Open SSMS to set your preferred feature, instance and DB options, and then backup the sys DB’s!

Ready to go!

Posted on: July 16, 2013, by : sql contributor

Leave a Reply