Comments
Microsoft Releases In-Memory Ready SQL Server 2014
Newest First  |  Oldest First  |  Threaded View
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

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

 
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.


IT's Reputation: What the Data Says
IT's Reputation: What the Data Says
InformationWeek's IT Perception Survey seeks to quantify how IT thinks it's doing versus how the business really views IT's performance in delivering services - and, more important, powering innovation. Our results suggest IT leaders should worry less about whether they're getting enough resources and more about the relationships they have with business unit peers.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest September 24, 2014
Start improving branch office support by tapping public and private cloud resources to boost performance, increase worker productivity, and cut costs.
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.