Feeds

Microsoft boasts of Big Data chops for in-memory SQL

Data warehousing gets handier with Hadoop

Providing a secure and efficient Helpdesk

Microsoft claims that new in-memory data processing capabilities in the next build of SQL will improve performance by a factor of fifty compared to current speeds.

"We're bringing an in-memory transactional capability to SQL Server," said Ted Kummert, corporate vice president of the Business Platform Division, in his keynote presentation at the Professional Association for SQL Server (PASS) conference in Seattle. "And this thing is wicked fast."

He demoed the software, codenamed Hekaton thus far, using applications in-memory without the need for coding changes, at speeds of between nine and 30 times current performance. Microsoft has put a lot of work into ensuring that applications can be converted to in-memory processing with the minimum of recoding, Leland said.

Hekaton is going to be built into the next major build of SQL Server, he said, although no timeframe was given. In the first half of next year, however, SQL will also get a refresh of Microsoft's Parallel Data Warehouse (PDW) with a new data processing engine dubbed PolyBase that can handle both relational data and non-relational databases run on Microsoft's version of Hadoop.

"This thing's built for Big Data," Kummert said. "From the storage architecture, dramatically lower cost pre terabyte, performance, and now we're introducing PolyBase to unify the relational and non-relational worlds at the query level."

As for the here and now, Wednesday sees the release of the first service pack for SQL Server 2012, which brings more integration of SQL into Office applications. In particular, Excel is getting a makeover to fold Power View and Power Pivot controls more closely into Excel to increase its usefulness in business intelligence apps.

"Excel is now the complete end-user BI tool," Kummert promised. ®

Beginner's guide to SSL certificates

More from The Register

next story
ONE MILLION people already running Windows 10
A third of them are doing it in VMs, but early feedback focuses on frippery
Sign off my IT project or I’ll PHONE your MUM
Honestly, it’s a piece of piss
Netscape Navigator - the browser that started it all - turns 20
It was 20 years ago today, Marc Andreeesen taught the band to play
Torvalds CONFESSES: 'I'm pretty good at alienating devs'
Admits to 'a metric ****load' of mistakes during work with Linux collaborators
Sway: Microsoft's new Office app doesn't have an Undo function
Content aggregation, meet the workplace ... oh
Do Moan! MONSTER 6-day EMAIL OUTAGE hits Domain Monster
Customers freaked out by frightful service
Ploppr: The #VultureTRENDING App of the Now
This organic crowd sourced viro- social fertiliser just got REAL
Return of the Jedi – Apache reclaims web server crown
.london, .hamburg and .公司 - that's .com in Chinese - storm the web server charts
NetWare sales revive in China thanks to that man Snowden
If it ain't Microsoft, it's in fashion behind the Great Firewall
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Win a year’s supply of chocolate
There is no techie angle to this competition so we're not going to pretend there is, but everyone loves chocolate so who cares.
Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.