Comments
Microsoft Releases In-Memory Ready SQL Server 2014
Threaded  |  Newest First  |  Oldest First
Laurianne
50%
50%
Laurianne,
User Rank: Author
3/18/2014 | 12:53:34 PM
MS SQL Server
Great context here, Doug. The point re SAP Hana is not lost on customers, either, I'm sure.
Lorna Garey
50%
50%
Lorna Garey,
User Rank: Author
3/18/2014 | 1:20:08 PM
Re: MS SQL Server
Doug, Any word on cost? Is Microsoft going to provide the in-memory capability in the standard release, or will customers need to pony up for higher-end versions?
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
3/18/2014 | 4:56:45 PM
Re: MS SQL Server
In-Memory OLTP is a standard feature, not an extra-cost feature. It's an "option" in that it's there if you need it, but you don't have to put tables into memory if you don't need that acceleration.

 

Pricing of the database has not been released.
D. Henschen
50%
50%
D. Henschen,
User Rank: Author
3/18/2014 | 1:19:22 PM
Boster's big-data analysis opportunities.
Microsoft's Quentin Clark tells me that some customers have used In-Memory OLTP tables in a high-scale caching role (think Memcached) whereby a in-memory table is used for high-scale, high-speed ingest. In this role it acts as a kind of data shock absorber where data can be buffered, transformed and delivered to a variety of applications and analyses. I'm sure there will be many novel implementations of in-memory tables that Microsoft never envisioned. 

I'm sure this release also will heat up the ongoing market-share battle with Oracle. Microsoft SQL Server gained front-runner status in terms of unit sales many years ago. Clark tells me the latest stats from IDC show that SQL Server recently eclipsed IBM DB2 in terms of software revenue market share among DBMSs. 

Microsoft is counting on lower SQL Server costs to win the day against Oracle Database. Oracle points to scalability and industrial-strength perfomance, but Microsoft's new In-Memory OLTP option will help on that score. Stay tuned, though, as Oracle is epected to introduce its own in-memory capabilities this year. This was pre-announced at Oracle Open World last year, but this year expect beta product announcements at OOW 2014 and general release late this year or early next year.

 
Charlie Babcock
50%
50%
Charlie Babcock,
User Rank: Author
3/18/2014 | 3:21:55 PM
A big step
This is a big step forward in Microsoft's database capabilities. The ability to use SQL Server on premises and synch with a version of SQL Server in Azure will spur Azure use.
NaiyingL805
50%
50%
NaiyingL805,
User Rank: Apprentice
3/19/2014 | 2:24:47 PM
i agree with you
When there's 35 million ring fenced for mental health as there was this year and hopefully again next year it's not good enough for the HSE to just do as they wish with it.. There are a many green alkaline drinks that promote health and overall well being. More importantly, stay away from simple carbs like table sugar, cakes, candies, and white bread. My doctor couldn remember my name after 5 months. Population and States may not be able to pull in these individuals into health care exchanges, unless strategic steps were incorporated to address the language and other enrollment barriers, these individuals faced. chanel outlet online gucci borse
VladiV579
50%
50%
VladiV579,
User Rank: Apprentice
5/29/2014 | 5:27:41 AM
Capabilities and Limitations of SQL 2014 In-Memory and other In-Memory Caching solutions
Hi,
Thanks for this good article.
I found another very interesting and very comprehensive article about the SQL Server 2014 capabilities, limitations, migration plan options:

http://blog.sqlauthority.com/2014/04/30/sql-server-faster-application-performance-with-in-memory-oltp-microsoft-sql-server-2014-and-safepeak-dynamic-caching/

It also compares the new In-Memory OLTP engine with few additional technologies, including the automated dynamic caching solution by SafePeak

 


The Business of Going Digital
The Business of Going Digital
Digital business isn't about changing code; it's about changing what legacy sales, distribution, customer service, and product groups do in the new digital age. It's about bringing big data analytics, mobile, social, marketing automation, cloud computing, and the app economy together to launch new products and services. We're seeing new titles in this digital revolution, new responsibilities, new business models, and major shifts in technology spending.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest - August 20, 2014
CIOs need people who know the ins and outs of cloud software stacks and security, and, most of all, can break through cultural resistance.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.