Feeds

Microsoft boasts of Big Data chops for in-memory SQL

Data warehousing gets handier with Hadoop

Secure remote control for conventional and virtual desktops

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

Secure remote control for conventional and virtual desktops

More from The Register

next story
Microsoft boots 1,500 dodgy apps from the Windows Store
DEVELOPERS! DEVELOPERS! DEVELOPERS! Naughty, misleading developers!
'Stop dissing Google or quit': OK, I quit, says Code Club co-founder
And now a message from our sponsors: 'STFU or else'
Apple promises to lift Curse of the Drained iPhone 5 Battery
Have you tried turning it off and...? Never mind, here's a replacement
Uber, Lyft and cutting corners: The true face of the Sharing Economy
Casual labour and tired ideas = not really web-tastic
Mozilla's 'Tiles' ads debut in new Firefox nightlies
You can try turning them off and on again
Linux turns 23 and Linus Torvalds celebrates as only he can
No, not with swearing, but by controlling the release cycle
prev story

Whitepapers

5 things you didn’t know about cloud backup
IT departments are embracing cloud backup, but there’s a lot you need to know before choosing a service provider. Learn all the critical things you need to know.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Backing up Big Data
Solving backup challenges and “protect everything from everywhere,” as we move into the era of big data management and the adoption of BYOD.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
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?