The Register® — Biting the hand that feeds IT

Feeds

No joke: Microsoft SQL Server 2012 debuts on April Fools' Day

Hadoop, Azure also look for more partners

Customer Success Testimonial: Recovery is Everything

As expected Microsoft has released SQL Server 2012, formerly codenamed Denali, to manufacturers and will be making the final code available on April Fools' Day.

"This is the cusp of a major milestone for Microsoft and SQL Server," Doug Leland, GM of SQL marketing for Redmond told The Register. "It's been battle-tested by over 150,000 customers and is ready to go."

The new build, available in standard, business intelligence and enterprise editions, has been designed specifically with big data uses in mind, and Leland reckons it works with structured and unstructured data sets faster than any previous version. The use of in-memory processing for tables was one area where significant speed increases have been achieved.

Stability has also been addressed, and one beta tester, the Home Shopping Network, saw downtime cut by a factor of 10 in testing. The PowerView data analysis tool has been added to the existing PowerPivot system and this version of SQL will also have greater support for hybrid cloud systems that mix on-premise and external databases.

Microsoft commissioned a report on upgrading to SQL Server by analyst house Forrester and this estimated that updating would pay for itself within 12 to 14 months with an estimated return on investment between 149 and 189 per cent. Redmond will hold a corporate webcast on Wednesday with more details.

Leland also confirmed that the proposed integration with Hadoop on Microsoft's Azure platform would be continuing apace, with a new beta for the system due out in the second half of the year. The company is also widening the range of companies who can try the system early, and users can sign up to take part on the Azure website.

The software will include features suggested by participants, and among the new stuff is support for the Mahout open source library for advanced predictive analytics and improved failover that should see the software become much more resilient to downtime. ®

Agentless Backup is Not a Myth

On a Sunday?

Really?

2
0

SQL server 2012.....Wait, What!

Well I suppose it's another upgrade path to consider, when my beloved SQL 2000 servers reach their end of life in 2013.

1
0
Anonymous Coward

Re: it is broken

-- a Common Table Expression will work :

With Safe_CTE as

(

SELECT i FROM x WHERE i <> 0

)

SELECT 1 / i FROM Safe_CTE

-- Of course, if i is an integer type, your results aren't going to be very useful!

1
0

More from The Register

Bjarne Again: Hallelujah for C++
Plus: Now officially OK to admit you never used STL algorithms
Interwebs taunt Sir Jony over Apple eye candy makeover
Hey Ive, Ive... add more unicorns, willya?
SCO vs. IBM battle resumes over ownership of Unix
Zombie lawsuit back and wants to suck the brains out of Linux
Red Hat to ditch MySQL for MariaDB in RHEL 7
So long, Oracle! Don't let the door hit you on the way out
Shy? Socially inadequate? Fiddling with your phone could help
App 'tells the brutal truth' about social inadequates' chatup lines
Java EE 7 melds HTML5 with enterprise apps
New release arrives with GlassFish, NetBeans support
 breaking news
'Office Facebook' firm Tibbr wants you to PAY for mobe-meetings app
Great idea. Punters won't cough for it though
 breaking news
The only Waze is Google: Ad giant tipped to gobble map app 'for $1.3bn'
Pac-Man-satnav-ish upstart in bidding war with Apple, Facebook
 breaking news
PM Cameron calls for modern, programmable computers! (We think)
IT education musings to G8 chiefs to mystify IT industry
Apple at WWDC: Sleek new iOS, death of the big cats, pint-sized Mac Pro
CEO Cook: 'The biggest change to iOS since the introduction of the iPhone'