Wednesday, October 16, 2013

Microsoft SQL Server CTP2 announced...

Microsoft SQL Server CTP2 announced...

Microsoft SQL Server 2014 brings to market new in-memory capabilities built into the core database and provides new cloud capabilities to simplify cloud adoption for your SQL databases and help you unlock new hybrid scenarios.
 
Key SQL 2014 Architecture features and improvements:
 
1.) Provides new disaster recovery and backup solutions with Windows Azure, enabling customers to use their existing skills with the on-premises product offerings to take advantage of Microsoft’s global datacenters.
2.) Code named "Hekaton" is now known simply "In-Memory" Online Transaction Processing (OLTP). In-Memory OLTP will let administrators move selected tables into main memory, thereby delivering performance improvements without having to touch the actual applications.
3.) Support for additional index types.
4.) Natively compiled stored procedures for efficient execution of business logic.
5.) New tools to help administrators access database performance so that they can determine which tables would most benefit from in-memory optimization.
 
Download Microsoft SQL Server 2014 here:
 
Here's more to In memory architecture overview of SQL server 2014 -
 
Tech net blog on how to get started with SQL 2014 -
 
Hardware Considerations for SQL Server 2014 (Microsoft does claim backward compatibility -if you can run your applications on SQL 2012, you can run on SQL 2014)-
 
Final release expected to be announced sometime later half of CY 2014, but will learn more from developer community as we play around this!
 
Pass Summit 2013 is going on now... stay tuned for more innovation!!!
 
Cheers - Dipesh

No comments: