Violin Memory's Steve Willson gave part of the game away on March 24, with a TechNet UK blog post: Violin's new array runs SQL 2014 in memory. Willson wrote: SQL 2014's new in-memory computing takes several leaps forward in performance and control. Application designers can now control what data is permanently staged in memory …
This has been on their web site for quite a long time now.
If a storage vendor can't write or license anything else to provide higher order capabilities for their array, there's always Windows available.
SQL Server 2014 Embedded
Probably worth updating the article to point to this link Chris: http://blogs.msdn.com/b/windows-embedded/archive/2014/03/18/microsoft-sql-server-2014-now-available-to-direct-oems.aspx
The SQL Server community in the UK is massive with SQL Relay, SQL Bits, SQL Saturday and dozens of regional user groups, the reason I mention, it's nothing new that Fusion-IO, Violin and other storage vendors have for the past couple of years been showing off these capabilities through talks, sponsorship etc..
The real story here is that SQL Server 2014 embedded is available for OEM, we've had SQL Server appliances for SQL Server 2012 for a while now but built around DASD made up by spindles; the flash move is something new. The Buffer Pool extensions to SQL Server have been introduced as a cost effective method of circumventing the significant cost of producing the IOps required from a SAN architecture.
Roll on the day hey - we are all on commodity storage in the cloud or embedded SQL Server in an appliance so we no longer have to move our data across 8 or 16Gbit connections from the SAN into the server (move the program to the data rather than the data to the program).
This is nothing new
Sgi did this with Oracle and Informix back in the nineties. The only issue was the horrendously priced memory. 4TB sat you back several million Usd, and you could at that time max get 8GB per 2xR10K nodeboard, so you needed 1024cpus to drive the memory. SGI. sold several 32 and 64 cpu configs with maxed memory just to run shmem in memory databases.
Err when did Microsft become sql de facto ??
Excuse me - Microsoft sql server is most definitely NOT SQL 2014 - In fact it is probably the least standards complaint of the main sql db offerings - Postgres is far more compliant for example.
- Review This is why we CAN have nice things: Samsung Galaxy Alpha
- Ex-Soviet engines fingered after Antares ROCKET launch BLAST
- Hate the BlackBerry Z10 and Passport? How about this dusty old flashback instead?
- NASA: Spacecraft crash site FOUND ON MOON RIM
- Apple spent just ONE DOLLAR beefing up the latest iPad Air 2