Home > SQL Server 2014 > Finally installed SQL Server 2014 CTP1

Finally installed SQL Server 2014 CTP1


Last month I posted the availability of the first Community Test Preview (CTP-1) of SQL Server 2014, [link].

As mentioned officially by Microsoft this preview (CTP-1) should be installed on a fresh OS (Windows 8 or Server 2012) and not with existing Dev machine. So, some days back I finally managed to get an isolated machine and installed on it. The Installation is similar to SQL Server 2012, only difference is the version number till now.

After successful install on opening SSMS you will see following Splash Screen with 2014 branding:
SQLServer2014_SplashScreen

.
–> On checking the version by SQL statement you get:
SQLServer2014Version2

.
–> On checking the “Tables” section on Object Explorer it gives you option to create “Memory Optimized Tables”:
SQLServer2014HekatonTables
… but this is not graphical (like Create Table), it provides a Script template and opens it in SQL Query Editor.

.
–> On checking the “Stored Procedures” section on Object Explorer it gives you option to create “Natively Compiled Stored Procedures”:
SQLServer2014HekatonSPs
… and just like “Create Procedure” it also provides a Script template and opens it in SQL Query Editor.

Next post I’ll come with some hands-on with Creating a Database, Memory Optimized tables and new things introduced in SQL Server 2014.

Advertisement
  1. August 1, 2013 at 8:57 pm

    Nice one Manoj – You being lucky to find a separate Dev machine – Any chances of installing it in a machine that has SQL 2012 ?? Does it give any upgrade option ??

    • August 2, 2013 at 10:33 am

      Thanks for your comments Saurabh!!!

      No, SQL Server 2014 should be a clean install, no upgrade from previous versions.
      And as mentioned in my previous post, the machine should have new OS installed without any previous version of SQL Server, related softwares and no Visual Studio installed, it won’t install otherwise.

  1. September 25, 2013 at 6:08 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: