At the SQL PASS Summit on October 12, Microsoft’s Ted Kummert, CVP, Business Platform Division, confirmed that the codenamed SQL Server “Denali” will be officially named SQL Server 2012 when it ships in the first part of 2012.
Kummert described how SQL Server 2012, formerly code-named “Denali,” addresses the growing challenges of data and device proliferation by enabling customers to rapidly unlock and extend business insights, both in traditional datacenters and through public and private clouds.
“SQL Server 2012 delivers a powerful new set of capabilities for mission-critical workloads, business intelligence and hybrid IT across traditional datacenters and private and public clouds.”
“Features such as Power View (formerly Project “Crescent,”) and SQL Server Data Tools (formerly “Juneau”) expand the self-service BI capabilities delivered with PowerPivot, and provide an integrated development environment for SQL Server developers.”
The new ColumnStore Index delivers over 10x data warehouse performance gains. Due out in the first half of 2012, SQL Server 2012 is in the final production stages, with hundreds of customers going into production in CTP3, including Edgenet Inc., Sanofi Pasteur SA, Mediterranean Shipping Co. SA, Pilot Travel Centers LLC and Great Western Bank.
He also announced new investments to help customers manage “big data,” including an Apache Hadoop-based distribution for Windows Server and Windows Azure and a strategic partnership with Hortonworks Inc.
Microsoft is going to be working with Hadoop core contributors from Yahoo Hadoop spinoff Hortonworks. Microsoft and Hortonworks are readying a CTP test build of their Hadoop-based service for Windows Azure for delivery before the end of calendar 2011 and a CTP of the Hadoop-based distribution for Windows Server some time in 2012. The new stacks will work with Microsoft’s business-intelligence tools, including Excel, PowerPivot and PowerView (the new data-analysis technology that is part of SQL Server 2012 and was formerly known by its codename “Crescent”).
“The new addition of an Apache Hadoop-based distribution for Windows Azure and Windows Server is the next building block, seamlessly connecting all data sizes and types. Coupled with our new investments in mobile business intelligence, and the expansion of our data ecosystem, we are advancing data management in a whole new way,” said Kummert.
Microsoft is continuing to work on various alternatives to Java-based Hadoop and MapReduce and is “still committed” to these efforts, said Doug Leland, General Manager of Product Management in Microsoft’s Business Platform Marketing Group. Microsoft’s home-grown Hadoop competitor, aimed at .Net developers, is “Dryad” — or as it is currently known, LINQ to HPC. Microsoft Research also fielded earlier this year a technology preview of “an iterative MapReduce runtime for Windows Azure,” codenamed “Daytona,” that is meant to support data analytics and machine-learning algorithms which can scale to hundreds of server cores for analyzing distributed data.
Also, made available was the final versions of the Hadoop Connectors for SQL Server and Parallel Data Warehouse. “Customers can use these connectors to integrate Hadoop with their existing SQL Server environments to better manage data across all types and forms,” said Kummert.
You can download Microsoft SQL Server Connector for Apache Hadoop here.
Kummert also demonstrated Microsoft code-name “Data Explorer,” a prototype that provides a way for customers to easily discover, enrich and share data to gain competitive advantage in today’s business climate.
“When combined with Windows Azure MarketPlace, now available in 26 worldwide markets, Data Explorer will help customers realize their data’s full potential.”
Customers are encouraged to begin testing and to provide feedback when CTPs are made available in the SQL Azure Labs later this year at SQL Azure Labs.