|By Jayaram Krishnaswamy||
|March 18, 2014 11:13 PM EDT||
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.
For more information read these articles:
This talk focuses on the application of DevOps fundamentals to include network infrastructure. It draws from real deployment case studies on the extension of today's paradigms to address the challenges of the network infrastructures' ability to seamlessly and cohesively integrate into agile workflows. In this session at DevOps Summit, Arista Networks will focus on configuration management using automation with a nod to future work necessary to include telemetry and ephemeral state information....
May. 5, 2015 04:45 PM EDT Reads: 1,063
May. 5, 2015 04:15 PM EDT Reads: 854
May. 5, 2015 04:02 PM EDT Reads: 296
May. 5, 2015 03:45 PM EDT Reads: 817
May. 5, 2015 03:30 PM EDT Reads: 870
May. 5, 2015 03:00 PM EDT Reads: 793
May. 5, 2015 02:53 PM EDT Reads: 310
May. 5, 2015 02:37 PM EDT Reads: 279
May. 5, 2015 02:30 PM EDT Reads: 3,374
May. 5, 2015 02:15 PM EDT Reads: 5,301
May. 5, 2015 02:00 PM EDT Reads: 406
May. 5, 2015 02:00 PM EDT Reads: 1,116
May. 5, 2015 01:15 PM EDT Reads: 1,241
May. 5, 2015 12:15 PM EDT Reads: 684
May. 5, 2015 12:00 PM EDT Reads: 5,128