Tuesday, March 18, 2014

SQL Server 2014 will be available on April 1

SQL Server 2014 RTM, billed as 'Microsoft Cloud First Platform' will be RTM on April 1, 2014
The main feature is the in-memory OLTP processing which will turbo- charge transaction processing making it as much as 30 times faster. In order to use this feature you need memroy-optimized databases and tables declared as memory optimized. These memory-optimized tables are stored in file groups.

In-memory transaction processing appears to be not new, but peer pressure from products already in the market makes it important to highlight this feature in this offering as it is fully integrated with the present version.

The other prominent feature is the enhancements to Microsoft Azure in particular the enhancements leading to integration between on premises and cloud based environments. SQL Server 2014 instances can be backed up to Windows Azure Storage which can then be deployed as Windows Azure VM by just invoking a wizard. This  can then be designated as a high availability node for SQL Server 2014.

Of course to reap all this benefit you need to purchase SQL Server 2014. I know people using SQL Server 2000 even now, I assume it is still supported.

There will be an upgrade path but not sure it will be from CTP1 version to RTM. Remove CTP1 version and clean up.

For more information read these articles:
http://www.infoworld.com/t/dbms/sql-server-2014-supercharged-in-memory-tables-azure-connectivity-238639?source=IFWNLE_nlt_daily_pm_2014-03-18

http://www.zdnet.com/microsofts-sql-server-2014-crowns-redmonds-data-platform-7000027444/

Brief over view of Memory-Optimized tables:
Two types of Memory-Optimized tables in SQL Server 2014
1. SCHEMA_AND_DATA
2. SCHEMA_ONLY

SCHEMA_AND_DATA Table
Remains in memory
Can be accessed after
  Server Crash
  shutdown
  Restart

SCHEMA_ONLY Table
Does not persist data after
  Server Crash
  Shutdown
  Restart
but the table structure is retained

To create these tables you need a database, in this case you need a MEMORY-OPTIMIZED database which supports MEMORY-OPTIMIZED tables. This is where the  file groups came in. You create a MEMORY-OPTIMIZED database with and store in file group.
You can create a MEMORY-OPTIMIZED database using SQL Server Management Studio or using script.