SQL with Manoj

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:

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

.
–> On checking the “Tables” section on Object Explorer it gives you option to create “Memory Optimized Tables”:

… 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”:

… 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.