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

IT infrastructure monitoring strategies
Agentless Backup is Not a Myth
Top 10 SIEM implementer’s checklist
Steps to Take Before Choosing a Business Continuity Partner
Enabling efficient data center monitoring